History of the file that is called src/include/lib/Garradin/Accounting/Reports.php at checkin 0bc6030888babc72

2024-03-08
22:53
Show reconciliation status in accounts list file: [ab6f1e99ca] check-in: [189a2a3ac0] user: bohwaz, branch: trunk, size: 21658 [annotate] [blame] [check-ins using] [diff]
2024-01-20
16:34
Revert split of acc_transactions_users in two tables as it would make fiscal receipts SQL code much more complex file: [ef64e160e0] check-in: [20c66e6cb7] user: bohwaz, branch: dev, size: 21477 [annotate] [blame] [check-ins using] [diff]
2024-01-17
22:41
Rename table services_users to services_subscriptions, and split acc_transactions_users in two tables, one for users and one for subscriptions file: [9c56e3231a] check-in: [28a33baea9] user: bohwaz, branch: dev, size: 21485 [annotate] [blame] [check-ins using] [diff]
18:31
Implement expert view in users general balance file: [e7c25e62cb] check-in: [e455a82562] user: bohwaz, branch: trunk, size: 21474 [annotate] [blame] [check-ins using] [diff]
2023-12-22
16:03
Fix projects order in analytical ledger file: [e71e9321d9] check-in: [270aeb7d38] user: bohwaz, branch: trunk, size: 21437 [annotate] [blame] [check-ins using] [diff]
2023-12-02
17:57
Group projects correctly in analytical ledger file: [0868d73fb2] check-in: [dc904db9aa] user: bohwaz, branch: trunk, size: 21419 [annotate] [blame] [check-ins using] [diff]
2023-09-05
00:54
Merge changes from trunk file: [8086dfa48b] check-in: [be589e6fcc] user: bohwaz, branch: dev, size: 21353 [annotate] [blame] [check-ins using] [diff]
2023-09-02
14:29
Fix links for reports for all projects for a year file: [9fc7c83c35] check-in: [3d9865854e] user: bohwaz, branch: trunk, size: 20962 [annotate] [blame] [check-ins using] [diff]
2023-08-22
15:36
Merge with trunk file: [115d2bc417] check-in: [8b8480b44b] user: bohwaz, branch: dev, size: 21300 [annotate] [blame] [check-ins using] [diff]
14:12
Group accounts by code, not by ID, when getting balances on multiple years file: [7740ad8a82] check-in: [b584e319b5] user: bohwaz, branch: trunk, size: 20909 [annotate] [blame] [check-ins using] [diff]
2023-08-10
14:06
Display account in analytical ledger file: [24296dfbec] check-in: [ea8156bd51] user: bohwaz, branch: dev, size: 21234 [annotate] [blame] [check-ins using] [diff]
2023-07-21
13:28
Renamed src/include/lib/Garradin/Accounting/Reports.php → src/include/lib/Paheko/Accounting/Reports.php. Rename everything from Garradin to Paheko file: [10927bec1e] check-in: [736b20220e] user: bohwaz, branch: dev, size: 21098 [annotate] [blame] [check-ins using] [diff]
2023-06-03
23:53
Reverse order of transactions for users file: [be49fc6e79] check-in: [55a079fb33] user: bohwaz, branch: dev, size: 21112 [annotate] [blame] [check-ins using] [diff]
2023-05-26
17:13
Fix projects ledger file: [0f7acbbe10] check-in: [b0103c221f] user: bohwaz, branch: dev, size: 21042 [annotate] [blame] [check-ins using] [diff]
2023-03-30
00:44
Merge with trunk file: [9e564a8732] check-in: [d54a7c5a1f] user: bohwaz, branch: dev, size: 20986 [annotate] [blame] [check-ins using] [diff]
2023-03-27
02:05
Use TableTo* to export HTML statement table to ODS/CSV, refactor statement table to be in a single HTML table file: [cb5eff4048] check-in: [fa279fb669] user: bohwaz, branch: trunk, size: 20908 [annotate] [blame] [check-ins using] [diff]
2023-02-14
22:29
Refactor plugins to have the same UI for plugins and modules, also modernize code of plugins management file: [da4d116997] check-in: [a8251477ac] user: bohwaz, branch: dev, size: 22386 [annotate] [blame] [check-ins using] [diff]
2023-01-13
16:30
Merge trunk changes file: [428de3f988] check-in: [4e559e8fb6] user: bohwaz, branch: dev, size: 22451 [annotate] [blame] [check-ins using] [diff]
2023-01-07
21:50
Fix year comparison of projects where the mentioned year does not have anything related to this project file: [9a3d384a70] check-in: [f526f4c6fb] user: bohwaz, branch: trunk, size: 22308 [annotate] [blame] [check-ins using] [diff]
20:53
Only aggregate balances when grouped file: [31f657f6c2] check-in: [31e994fe47] user: bohwaz, branch: trunk, size: 21320 [annotate] [blame] [check-ins using] [diff]
20:34
Fix display of project statement for all years, when the account is from different accounting charts file: [3d79f36b04] check-in: [b340688768] user: bohwaz, branch: trunk, size: 21279 [annotate] [blame] [check-ins using] [diff]
2023-01-04
19:17
Keep empty accounts in balance, if used during the year file: [27d8849e11] check-in: [0d9f5f1cb0] user: bohwaz, branch: trunk, size: 21188 [annotate] [blame] [check-ins using] [diff]
2022-12-31
13:45
Implement expert accounting preference, replace "simplfied" tabs file: [2e1283cd19] check-in: [6136761998] user: bohwaz, branch: dev, size: 21305 [annotate] [blame] [check-ins using] [diff]
2022-11-17
23:41
Add date filter on accounting reports file: [709bf1223c] check-in: [9a298da40c] user: bohwaz, branch: trunk, size: 21162 [annotate] [blame] [check-ins using] [diff]
2022-11-16
02:18
Add export to CSV/ODS for statement result file: [c147226f8e] check-in: [e3475ee468] user: bohwaz, branch: trunk, size: 20658 [annotate] [blame] [check-ins using] [diff]
2022-11-15
12:43
Fix volunteering totals file: [a40d69dbc3] check-in: [b6b889cbb0] user: bohwaz, branch: trunk, size: 19240 [annotate] [blame] [check-ins using] [diff]
2022-11-12
18:54
Do not display graphics if there are not enough transactions file: [5b30a38945] check-in: [f647688115] user: bohwaz, branch: trunk, size: 19216 [annotate] [blame] [check-ins using] [diff]
2022-11-07
13:37
Always show other bookmarked accounts in grouped lists file: [ee934a3c82] check-in: [6d2d1a3bbb] user: bohwaz, branch: next2, size: 18821 [annotate] [blame] [check-ins using] [diff]
2022-11-05
02:53
Fix projects migration when same project exists on multiple years file: [22353fbb2e] check-in: [93386339e6] user: bohwaz, branch: accounts_refactor, size: 18549 [annotate] [blame] [check-ins using] [diff]
2022-11-01
01:07
Improve chart changing file: [ea96bed23c] check-in: [320eec3417] user: bohwaz, branch: accounts_refactor, size: 18546 [annotate] [blame] [check-ins using] [diff]
2022-10-29
14:29
Move projects list to its own subdirectory file: [4fbfec179a] check-in: [b8a4aeba2a] user: bohwaz, branch: accounts_refactor, size: 18647 [annotate] [blame] [check-ins using] [diff]
14:13
Move to projects in objects file: [34cea0a3dc] check-in: [e21dadc0eb] user: bohwaz, branch: accounts_refactor, size: 21771 [annotate] [blame] [check-ins using] [diff]
2022-10-15
13:08
Make volunteering statement report more user-friendly, add total of volunteering and general statement file: [cc2a4b26e7] check-in: [2863b0e5b5] user: bohwaz, branch: trunk, size: 21821 [annotate] [blame] [check-ins using] [diff]
2022-07-28
01:32
Implement accounting in API file: [deeaa92307] check-in: [bda54dc686] user: bohwaz, branch: trunk, size: 20855 [annotate] [blame] [check-ins using] [diff]
2022-06-07
23:54
Fix comparison of year statement file: [31315d71f7] check-in: [0e48481e15] user: bohwaz, branch: trunk, size: 20846 [annotate] [blame] [check-ins using] [diff]
2022-04-24
01:21
Fix "asset or liability" accounts in projects reports file: [4754478645] check-in: [af4cceeef4] user: bohwaz, branch: trunk, size: 20152 [annotate] [blame] [check-ins using] [diff]
01:00
Group projects by code, not ID file: [7633520d72] check-in: [361d6987c4] user: bohwaz, branch: trunk, size: 19614 [annotate] [blame] [check-ins using] [diff]
2022-04-08
12:28
Fix totals in projects file: [de330c8227] check-in: [897385def3] user: bohwaz, branch: trunk, size: 19578 [annotate] [blame] [check-ins using] [diff]
2022-04-06
13:57
Drop acc_accounts_projects_balances view, we won't create a view for each specific accounts view (users, creator, analytical)

Instead use a generic SQL function to generate the correct SQL statement

Fix [852e29e7c9abea9c403ffb0e9a286b3b63ccebfa] file: [73e1a05e76] check-in: [80034eb770] user: bohwaz, branch: trunk, size: 19486 [annotate] [blame] [check-ins using] [diff]

2022-03-25
21:16
Fix bug in projects total view where balance was not added in multiple years, as reported by @zou file: [be83251967] check-in: [599540910a] user: bohwaz, branch: 1.1.23, size: 18484 [annotate] [blame] [check-ins using] [diff]
2022-03-18
01:45
Fix projects reports (thanks @zou) file: [ac1810d036] check-in: [c64ccd78ad] user: bohwaz, branch: 1.1.23, size: 18422 [annotate] [blame] [check-ins using] [diff]
2022-03-09
12:14
Fix projects view file: [5fcc95d2a3] check-in: [0e4a827f74] user: bohwaz, branch: trunk, size: 18596 [annotate] [blame] [check-ins using] [diff]
2022-03-07
04:11
Improve account list with new accounts positions file: [5b4927070c] check-in: [a04f43f63f] user: bohwaz, branch: trunk, size: 17949 [annotate] [blame] [check-ins using] [diff]
2022-03-04
00:26
Try to always use debit - credit as the default case file: [c950b00002] check-in: [89cbd2f12d] user: bohwaz, branch: trunk, size: 17895 [annotate] [blame] [check-ins using] [diff]
2022-03-03
18:59
Refactoring: remove getClosingSumsWithAccounts, use getAccountsBalance, fix graphs file: [a98c174ebd] check-in: [a1ef61e8d7] user: bohwaz, branch: trunk, size: 18042 [annotate] [blame] [check-ins using] [diff]
17:47
Use a SQL view to get accounts balances, makes it much easier to create statement and balance sheet, also change trial balance to have only one column file: [8d559cc680] check-in: [b2e7c79e5c] user: bohwaz, branch: trunk, size: 18575 [annotate] [blame] [check-ins using] [diff]
2022-02-13
22:17
Add totals to trial balance, as suggested by @Christian file: [77a691aec9] check-in: [7b5e6e0b19] user: bohwaz, branch: trunk, size: 18051 [annotate] [blame] [check-ins using] [diff]
2022-02-03
23:54
Fix balance sheet when comparing: was missing result and asset/liability may change columns file: [224caace98] check-in: [2718673a48] user: bohwaz, branch: trunk, size: 17563 [annotate] [blame] [check-ins using] [diff]
2022-02-01
23:50
Fix phpstan suggestions file: [ded6ab267e] check-in: [dc6013583c] user: bohwaz, branch: trunk, size: 16496 [annotate] [blame] [check-ins using] [diff]
2022-01-12
00:14
Switch to U_NOCASE collation file: [1d9d7b8cf9] check-in: [7e45abbf2c] user: bohwaz, branch: trunk, size: 16504 [annotate] [blame] [check-ins using] [diff]
2022-01-09
18:49
Fix: remove compare_year criteria when not useful file: [4ecd1e93c2] check-in: [466fc7c89b] user: bohwaz, branch: trunk, size: 16494 [annotate] [blame] [check-ins using] [diff]
2022-01-03
22:45
Make the code slightly more readable as it can be confusing file: [f4d459c763] check-in: [a748888b58] user: bohwaz, branch: trunk, size: 16457 [annotate] [blame] [check-ins using] [diff]
2021-12-30
13:20
Fix year comparison: don't hide empty accounts in year 0 if they were not empty in year-1 file: [9709a17af2] check-in: [51d87416af] user: bohwaz, branch: trunk, size: 16457 [annotate] [blame] [check-ins using] [diff]
2021-12-26
13:04
Don't make account code clickable when it is referring to another chart file: [6c7bf837e8] check-in: [b46a47e1a9] user: bohwaz, branch: trunk, size: 16465 [annotate] [blame] [check-ins using] [diff]
2021-12-19
00:06
Add ability to order projects either by code or by account label, defaut to account label file: [4b7b6a6df1] check-in: [cd73d694e0] user: bohwaz, branch: trunk, size: 16440 [annotate] [blame] [check-ins using] [diff]
2021-12-13
21:38
Sort accounts in comparison, according to account code, improve printing file: [fce3a571aa] check-in: [fa6b781b5b] user: bohwaz, branch: trunk, size: 16249 [annotate] [blame] [check-ins using] [diff]
2021-12-09
02:41
Reverse result when positive file: [b455a0ddd1] check-in: [49e35ff023] user: bohwaz, branch: trunk, size: 16233 [annotate] [blame] [check-ins using] [diff]
02:38
Fix sum change between two years file: [19f217be1d] check-in: [5d3d4ea90f] user: bohwaz, branch: trunk, size: 16198 [annotate] [blame] [check-ins using] [diff]
02:20
Implement comparison with a previous year in statements and balance sheets file: [a5abf1861c] check-in: [3b5fe1d41d] user: bohwaz, branch: trunk, size: 16073 [annotate] [blame] [check-ins using] [diff]
2021-11-30
19:08
Replace plot graph by bar graph in years page file: [73be02b3e0] check-in: [3b57e1df62] user: bohwaz, branch: trunk, size: 14619 [annotate] [blame] [check-ins using] [diff]
2021-09-22
00:36
Implement [8a9125e0a77426c27131c8131d100b26b3340def]: Analytical ledger file: [d37a6b0099] check-in: [02589eaf11] user: bohwaz, branch: trunk, size: 14088 [annotate] [blame] [check-ins using] [diff]
2021-05-10
15:35
In trial balance, always return accounts where closing sum is zero file: [0f2d41f8c0] check-in: [334d67dcae] user: bohwaz, branch: trunk, size: 13811 [annotate] [blame] [check-ins using] [diff]
2021-03-25
23:44
Order accounts by code in projects file: [5ea34ddcf7] check-in: [c7f099ceef] user: bohwaz, branch: dev, size: 13581 [annotate] [blame] [check-ins using] [diff]
2021-01-14
23:54
Fix issue with negative expense and revenue accounts file: [b07c8619b9] check-in: [b56673f847] user: bohwaz, branch: trunk, size: 13583 [annotate] [blame] [check-ins using] [diff]
2021-01-06
13:16
Don't add result to balance sheet if it's zero file: [1e89c4247c] check-in: [ea6a653118] user: bohwaz, branch: trunk, size: 13589 [annotate] [blame] [check-ins using] [diff]
2020-12-17
18:40
Fix projects revenus and expenses file: [0c4c46a2a9] check-in: [43b35b623e] user: bohwaz, branch: trunk, size: 13558 [annotate] [blame] [check-ins using] [diff]
00:17
Fix potential errors reported by PHPStan file: [d2cf5396b1] check-in: [f965328227] user: bohwaz, branch: trunk, size: 13534 [annotate] [blame] [check-ins using] [diff]
2020-12-14
21:47
Allow general ledger to span multiple charts file: [fefa848f8a] check-in: [560d6684ed] user: bohwaz, branch: trunk, size: 13449 [annotate] [blame] [check-ins using] [diff]
13:50
Add expense and revenues in projects view file: [1c0cdfccbb] check-in: [d1dbcfaa8d] user: bohwaz, branch: trunk, size: 13547 [annotate] [blame] [check-ins using] [diff]
2020-12-11
21:14
Oops file: [0a5171425b] check-in: [f815e596f6] user: bohwaz, branch: trunk, size: 13033 [annotate] [blame] [check-ins using] [diff]
21:13
Fix error in journal with account from other year file: [5e366c29c1] check-in: [1722a6d041] user: bohwaz, branch: trunk, size: 13042 [annotate] [blame] [check-ins using] [diff]
2020-12-08
00:58
Show volunteering accounts differently, mark them in the chart, and allow to select them in advanced transaction creation file: [657f1c3461] check-in: [b59f477a0f] user: bohwaz, branch: trunk, size: 13295 [annotate] [blame] [check-ins using] [diff]
2020-12-07
22:50
Add description in projects file: [3c67f495cc] check-in: [4804b1ad1a] user: bohwaz, branch: trunk, size: 12489 [annotate] [blame] [check-ins using] [diff]
2020-11-25
18:25
Add types for positive and negative result file: [bd1f8f1a69] check-in: [cc06f5744a] user: bohwaz, branch: dev, size: 12380 [annotate] [blame] [check-ins using] [diff]
2020-11-18
11:56
Fix liens vers total file: [68436d7eb6] check-in: [6e86bc54e8] user: bohwaz, branch: dev, size: 12219 [annotate] [blame] [check-ins using] [diff]
2020-11-14
09:53
Improve UX and print rendering file: [cc4d89a412] check-in: [602619e1bc] user: bohwaz, branch: dev, size: 12224 [annotate] [blame] [check-ins using] [diff]
2020-11-13
23:19
Don't show accounts with a sum of 0 file: [6a3f830e75] check-in: [2a23e4cca5] user: bohwaz, branch: dev, size: 12176 [annotate] [blame] [check-ins using] [diff]
15:20
Implement project view per year or per account file: [30c1bfeb1b] check-in: [546000f99d] user: bohwaz, branch: dev, size: 12157 [annotate] [blame] [check-ins using] [diff]
00:51
Better grouping of accounts in projects view file: [d2006809d6] check-in: [97cd46c544] user: bohwaz, branch: dev, size: 11343 [annotate] [blame] [check-ins using] [diff]
2020-11-12
19:23
Fix analytical report, missing a GROUP BY account.id statement, thanks @zou, @Jacques and @Fred file: [578f8c88a0] check-in: [88792aef79] user: bohwaz, branch: dev, size: 11282 [annotate] [blame] [check-ins using] [diff]
2020-11-11
22:21
Implement projects view (analytical) file: [c7e4d51456] check-in: [18c3a56ab9] user: bohwaz, branch: dev, size: 11276 [annotate] [blame] [check-ins using] [diff]
2020-11-08
02:11
Implement list of transactions linked to a service file: [61beb22b4d] check-in: [54b9d03a1c] user: bohwaz, branch: dev, size: 9775 [annotate] [blame] [check-ins using] [diff]
2020-11-03
03:22
Fix order issues with favorite accounts where account codes can differ file: [db2104d9f5] check-in: [fbae27973e] user: bohwaz, branch: dev, size: 10528 [annotate] [blame] [check-ins using] [diff]
2020-11-01
13:20
Fix: balance sheet had errors with negative sums. Some assets can be negative and must be left as negative. file: [bf3f721b5b] check-in: [12d73e8cb4] user: bohwaz, branch: dev, size: 10512 [annotate] [blame] [check-ins using] [diff]
01:37
Implement simple view in favourite accounts list, add button to create a transaction quickly from an account journal file: [ae426bd0a6] check-in: [f9a9d244e3] user: bohwaz, branch: dev, size: 10419 [annotate] [blame] [check-ins using] [diff]
2020-10-25
22:06
Fix issues with transaction import, eg. account code to account ID was flawed file: [4a67eae541] check-in: [96940550fd] user: bohwaz, branch: dev, size: 10336 [annotate] [blame] [check-ins using] [diff]
2020-10-23
18:08
Fix missing condition file: [008729b5d3] check-in: [0ab77f060e] user: bohwaz, branch: dev, size: 10201 [annotate] [blame] [check-ins using] [diff]
2020-10-21
14:54
Improve plot graphs file: [f05d387ae3] check-in: [504e540292] user: bohwaz, branch: dev, size: 10185 [annotate] [blame] [check-ins using] [diff]
2020-10-18
10:46
Make sure that we get a valid year file: [528acdb4b8] check-in: [ab80480535] user: bohwaz, branch: dev, size: 10175 [annotate] [blame] [check-ins using] [diff]
2020-10-17
17:01
Add more graphs file: [fa005c4ef4] check-in: [fa963fe834] user: bohwaz, branch: dev, size: 10137 [annotate] [blame] [check-ins using] [diff]
09:42
Implement pie charts file: [71a462b127] check-in: [0fa6b07811] user: bohwaz, branch: dev, size: 9841 [annotate] [blame] [check-ins using] [diff]
2020-10-16
14:56
Functional plot graphs for accounting file: [034df9631c] check-in: [d7e6950bd8] user: bohwaz, branch: dev, size: 9782 [annotate] [blame] [check-ins using] [diff]
01:13
Implementation start of graphs file: [d30f5b8640] check-in: [9b0d5d20d0] user: bohwaz, branch: dev, size: 9789 [annotate] [blame] [check-ins using] [diff]
2020-10-14
18:14
Implement: add account to chart file: [11a0817a06] check-in: [6d7d326267] user: bohwaz, branch: dev, size: 9384 [annotate] [blame] [check-ins using] [diff]
15:06
Fix: balance sheet and accounts that can be either assets or liabilities file: [d01896f10b] check-in: [babf7c84fc] user: bohwaz, branch: dev, size: 9384 [annotate] [blame] [check-ins using] [diff]
00:28
Implement: list of transactions created by a user file: [fd0f7f6398] check-in: [d8894bb1ef] user: bohwaz, branch: dev, size: 8020 [annotate] [blame] [check-ins using] [diff]
2020-10-12
20:20
Implement journal of transactions for a given user file: [9d73ee8a74] check-in: [cb235d75ca] user: bohwaz, branch: dev, size: 7909 [annotate] [blame] [check-ins using] [diff]
2020-10-11
17:24
Add: reconcile bank accounts file: [2a2f38b03f] check-in: [1467749329] user: bohwaz, branch: dev, size: 7710 [annotate] [blame] [check-ins using] [diff]
2020-10-10
23:22
Move account management to charts management, instead show current accounts sum for current year file: [59de19ed48] check-in: [4082ed3ad9] user: bohwaz, branch: dev, size: 6647 [annotate] [blame] [check-ins using] [diff]
2020-10-09
14:36
Add balance sheet file: [1da0cd20f9] check-in: [58f7cb1c31] user: bohwaz, branch: dev, size: 6066 [annotate] [blame] [check-ins using] [diff]
12:24
Add statement file: [ab8624feb2] check-in: [eb26468ca7] user: bohwaz, branch: dev, size: 5617 [annotate] [blame] [check-ins using] [diff]
11:05
Add year journal file: [740804e470] check-in: [58411fe14f] user: bohwaz, branch: dev, size: 5356 [annotate] [blame] [check-ins using] [diff]
10:15
Added: General ledger file: [085a5801bf] check-in: [65893d90e5] user: bohwaz, branch: dev, size: 3609 [annotate] [blame] [check-ins using]