History of the file that is called src/include/lib/Garradin/Recherche.php at checkin ae518b948af19799

2023-09-24
21:49
Flatten web directories for attachments, don't keep all folder hierarchy as it's too much work file: [9502b9219a] check-in: [67e3eab21e] user: bohwaz, branch: web-flatten, size: 7864 [annotate] [blame] [check-ins using] [diff]
2023-09-20
13:02
Ignore errors when counting results in mailing file: [68ae311a55] check-in: [3051c7a2ee] user: bohwaz, branch: dev, size: 7698 [annotate] [blame] [check-ins using] [diff]
2023-09-18
00:42
Fix debug file: [4c70ecaf95] check-in: [586d8b8a8a] user: bohwaz, branch: dev, size: 7550 [annotate] [blame] [check-ins using] [diff]
00:41
Fix forced LIMIT clause file: [67c640102a] check-in: [9dd079726b] user: bohwaz, branch: dev, size: 7563 [annotate] [blame] [check-ins using] [diff]
2023-09-17
14:36
Don't replace LIMIT inside sub-queries file: [3fbeb3771f] check-in: [d15945d871] user: bohwaz, branch: dev, size: 7541 [annotate] [blame] [check-ins using] [diff]
14:26
Don't remove trailing parenthesis when rewriting LIMIT clause file: [8d3ee9251c] check-in: [00e8757406] user: bohwaz, branch: dev, size: 7251 [annotate] [blame] [check-ins using] [diff]
00:42
Fix typo file: [8eced979fc] check-in: [0bde656762] user: bohwaz, branch: dev, size: 7153 [annotate] [blame] [check-ins using] [diff]
2023-09-15
18:56
Remove LIMIT on search when creating mailing file: [e2e0240047] check-in: [f8b5186ca1] user: bohwaz, branch: dev, size: 7166 [annotate] [blame] [check-ins using] [diff]
2023-08-24
01:48
Refactor UX of advanced features list file: [c57784c871] check-in: [ec8b3c8112] user: bohwaz, branch: dev, size: 7146 [annotate] [blame] [check-ins using] [diff]
2023-08-12
14:44
Fix typos file: [9ba1e935e9] check-in: [1fe975078b] user: bohwaz, branch: dev, size: 7122 [annotate] [blame] [check-ins using] [diff]
14:07
Make sure we lock the database against any write when doing a user query file: [f955ad5530] check-in: [bb70e3f555] user: bohwaz, branch: dev, size: 7121 [annotate] [blame] [check-ins using] [diff]
2023-07-21
13:28
Renamed src/include/lib/Garradin/Entities/Search.php → src/include/lib/Paheko/Entities/Search.php. Rename everything from Garradin to Paheko file: [06d1325ca1] check-in: [736b20220e] user: bohwaz, branch: dev, size: 6936 [annotate] [blame] [check-ins using] [diff]
2023-06-13
16:39
Do not throw an error in search list if query fails, instead ignore the search file: [217bab3109] check-in: [050a04cbb3] user: bohwaz, branch: dev, size: 6958 [annotate] [blame] [check-ins using] [diff]
13:05
Fix debug throw file: [2fc0db2364] check-in: [67b8e2339c] user: bohwaz, branch: dev, size: 6895 [annotate] [blame] [check-ins using] [diff]
2023-06-04
11:46
Fix: list of saved searches in mailing generated an error when a LIMIT was present file: [963f668a8c] check-in: [a823cbe5d1] user: bohwaz, branch: dev, size: 6908 [annotate] [blame] [check-ins using] [diff]
2023-05-30
16:09
Fix old code copy/paste when saving a search linked to a user file: [255ff632d7] check-in: [bf8bce2e38] user: bohwaz, branch: dev, size: 6897 [annotate] [blame] [check-ins using] [diff]
2023-04-28
20:29
Refactor mailing creation, preview and sending file: [3bf6c6ad87] check-in: [9b5769ef8f] user: bohwaz, branch: dev, size: 6899 [annotate] [blame] [check-ins using] [diff]
2023-04-27
22:11
Fix issues with email function in Brindille file: [0d6e6dfc74] check-in: [4833035098] user: bohwaz, branch: dev, size: 6491 [annotate] [blame] [check-ins using] [diff]
2023-04-24
21:27
Implement add to service from category, as suggested on Github: https://github.com/kd2org/paheko/pull/3/files file: [b21a24c4ed] check-in: [46001cf6d9] user: bohwaz, branch: dev, size: 6497 [annotate] [blame] [check-ins using] [diff]
2023-03-01
21:48
Fix search to use unicode LIKE, fix [555d13cb7087c709830813d0a518e767072c88bb] file: [3878b72b56] check-in: [9766c1623b] user: bohwaz, branch: dev, size: 6312 [annotate] [blame] [check-ins using] [diff]
2023-01-25
01:29
Show schema as tables, not raw SQL, in SQL search, also give access to more tables for user search, like in trunk file: [8226ea7bcc] check-in: [5a288b21b9] user: bohwaz, branch: dev, size: 6146 [annotate] [blame] [check-ins using] [diff]
2023-01-22
12:51
Allow read-only users to do SQL queries, extend SQL queries for users to services tables file: [1502bd3714] check-in: [be29a73150] user: bohwaz, branch: trunk, size: 21209 [annotate] [blame] [check-ins using] [diff]
2023-01-21
00:56
Use new Search object to do SQL queries from SQL advanced page file: [3c8b0f1365] check-in: [c5912d7a2c] user: bohwaz, branch: dev, size: 6067 [annotate] [blame] [check-ins using] [diff]
2022-11-08
00:42
Merge with trunk file: [c19e2a6cec] check-in: [3ca70608d9] user: bohwaz, branch: dev, size: 5448 [annotate] [blame] [check-ins using] [diff]
2022-11-06
22:07
Include acc_projects in search file: [4f2cd37c0a] check-in: [bd6b41404f] user: bohwaz, branch: trunk, size: 20765 [annotate] [blame] [check-ins using] [diff]
2022-10-29
14:13
Move to projects in objects file: [d8acf78ea5] check-in: [e21dadc0eb] user: bohwaz, branch: accounts_refactor, size: 20741 [annotate] [blame] [check-ins using] [diff]
2022-09-13
23:39
Define names and URLs for entities file: [118645601b] check-in: [d1d7c6a9f2] user: bohwaz, branch: dev, size: 5424 [annotate] [blame] [check-ins using] [diff]
2022-08-26
20:31
Fix advanced search where no criteria is left because the columns don't exist anymore file: [449eddb53a] check-in: [ed0cc60a3c] user: bohwaz, branch: dev, size: 5383 [annotate] [blame] [check-ins using] [diff]
2022-08-07
23:19
Use users_search table in search file: [5235b4f0c6] check-in: [f9ce20c14d] user: bohwaz, branch: dev, size: 5386 [annotate] [blame] [check-ins using] [diff]
22:57
Change wording for parent/children feature file: [7f67419860] check-in: [2ab90c453d] user: bohwaz, branch: dev, size: 5362 [annotate] [blame] [check-ins using] [diff]
2022-08-06
03:09
Refactor users selector file: [e3809b00a9] check-in: [8e27bf09e9] user: bohwaz, branch: dev, size: 5346 [annotate] [blame] [check-ins using] [diff]
2022-07-31
03:21
Implement generated columns as dynamic user fields file: [48ae9ecc83] check-in: [3b12525b6e] user: bohwaz, branch: dev, size: 5138 [annotate] [blame] [check-ins using] [diff]
2022-06-27
23:21
Merge trunk into dev file: [218cbdca8e] check-in: [8e3dffbfb1] user: bohwaz, branch: dev, size: 5311 [annotate] [blame] [check-ins using] [diff]
2022-06-04
11:00
Fix search for mailing to select all columns file: [77d31061bf] check-in: [8b74e0a682] user: bohwaz, branch: trunk, size: 20751 [annotate] [blame] [check-ins using] [diff]
2022-06-03
18:58
Merge latest trunk/emails to dev file: [8e429d2e9b] check-in: [42f4f0980c] user: bohwaz, branch: dev, size: 5081 [annotate] [blame] [check-ins using] [diff]
2022-04-04
01:22
Implement export of search also for SQL search file: [10ca5327f1] check-in: [4cd6bea2bb] user: bohwaz, branch: dev, size: 5200 [annotate] [blame] [check-ins using] [diff]
2022-04-03
18:30
Try to migrate saved searches to new schema file: [04cd8a1a66] check-in: [8465743e92] user: bohwaz, branch: dev, size: 5053 [annotate] [blame] [check-ins using] [diff]
17:54
Refactor saved searches file: [04e9a49497] check-in: [973cc37152] user: bohwaz, branch: dev, size: 5037 [annotate] [blame] [check-ins using] [diff]
00:38
Advanced search for accounting now works file: [741d5e34fa] check-in: [95382d5866] user: bohwaz, branch: dev, size: 5036 [annotate] [blame] [check-ins using] [diff]
2022-04-02
20:35
More progress on refactoring of search file: [c49de93a44] check-in: [44a8330da0] user: bohwaz, branch: dev, size: 4502 [annotate] [blame] [check-ins using] [diff]
18:46
Renamed src/include/lib/Garradin/Recherche.php → src/include/lib/Garradin/Entities/Search.php. Refactor search file: [e74071d71e] check-in: [4b14843367] user: bohwaz, branch: dev, size: 4216 [annotate] [blame] [check-ins using] [diff]
2022-01-12
00:14
Switch to U_NOCASE collation file: [469ee57460] check-in: [7e45abbf2c] user: bohwaz, branch: trunk, size: 20739 [annotate] [blame] [check-ins using] [diff]
2022-01-05
20:31
Make sure only date formats are treated as dates file: [91b2769fec] check-in: [1f2e1afdba] user: bohwaz, branch: trunk, size: 20735 [annotate] [blame] [check-ins using] [diff]
20:30
Fix quick search of account codes file: [af650b3ff1] check-in: [16d5a85a45] user: bohwaz, branch: trunk, size: 20687 [annotate] [blame] [check-ins using] [diff]
19:26
Allow quick search on transaction ID file: [1d60023550] check-in: [9da1f0cf33] user: bohwaz, branch: trunk, size: 20687 [annotate] [blame] [check-ins using] [diff]
19:02
Add quick search in accounting file: [dd734de895] check-in: [14b8d4df86] user: bohwaz, branch: trunk, size: 20550 [annotate] [blame] [check-ins using] [diff]
2021-09-14
22:41
Fix [5d0f7e9c9b42206046988b61a7deba6f8036d5d4] don't throw an error when a field doesn't exist anymore, just ignore it file: [5e796b3eb4] check-in: [937de7a7cc] user: bohwaz, branch: trunk, size: 18745 [annotate] [blame] [check-ins using] [diff]
2021-03-15
00:27
Rename category_id to id_category as for now everything else is still id_* so not really a good idea to have stuff all over the place file: [ee18756339] check-in: [c20cd8cd26] user: bohwaz, branch: dev, size: 18757 [annotate] [blame] [check-ins using] [diff]
2021-03-14
17:07
Remove calls to removed transliterate_to_ascii function file: [54b3431e02] check-in: [7c43a7fbb9] user: bohwaz, branch: dev, size: 18757 [annotate] [blame] [check-ins using] [diff]
2021-03-04
00:54
Add message to make clear that user and transaction files can not be managed from documents menu file: [55a56aa7c7] check-in: [2ea0f6d589] user: bohwaz, branch: dev, size: 19133 [annotate] [blame] [check-ins using] [diff]
2021-02-26
01:09
Merge changes from trunk file: [25cb8d4a11] check-in: [49124e29be] user: bohwaz, branch: dev, size: 19127 [annotate] [blame] [check-ins using] [diff]
2021-02-12
14:20
Remove duplicate search feature, add "save as new search" button instead file: [e91118fdd9] check-in: [3f97c1eb9c] user: bohwaz, branch: trunk, size: 19117 [annotate] [blame] [check-ins using] [diff]
2021-02-01
14:39
Fix issue with collective message when SELECT...FROM is on multiple lines file: [2b53c9624a] check-in: [99358d0e75] user: bohwaz, branch: trunk, size: 19374 [annotate] [blame] [check-ins using] [diff]
2021-01-28
19:22
Rename membres_categories to users_categories, change all references file: [d2da83f543] check-in: [d1a30a7827] user: bohwaz, branch: dev, size: 19383 [annotate] [blame] [check-ins using] [diff]
2021-01-24
00:45
Change default search order and descending/ascending depending on which type of search is used file: [18c1daa13e] check-in: [7669f3a7eb] user: bohwaz, branch: trunk, size: 19373 [annotate] [blame] [check-ins using] [diff]
2021-01-22
13:08
Fix search for decimal amounts in accounting file: [02c1a37ae1] check-in: [cb2b92e755] user: bohwaz, branch: trunk, size: 19047 [annotate] [blame] [check-ins using] [diff]
2021-01-19
13:35
Add SQL view in config to see what's going on file: [7a7550c4f7] check-in: [18f1a92627] user: bohwaz, branch: trunk, size: 19053 [annotate] [blame] [check-ins using] [diff]
2020-12-31
00:07
Set correct label for notes in French file: [d53f7c5508] check-in: [d24099a9c9] user: bohwaz, branch: trunk, size: 18589 [annotate] [blame] [check-ins using] [diff]
2020-12-29
19:27
Fix unprotected search run from collective message (thanks @JPHespel) file: [e0a0f10616] check-in: [b60ab7e57b] user: bohwaz, branch: trunk, size: 18585 [annotate] [blame] [check-ins using] [diff]
2020-12-17
00:17
Fix potential errors reported by PHPStan file: [881cfd9f9b] check-in: [f965328227] user: bohwaz, branch: trunk, size: 18508 [annotate] [blame] [check-ins using] [diff]
2020-12-08
17:03
Allow unprotected SQL queries, but only if created by someone who has access to main config file: [1d10925eeb] check-in: [820a6f443d] user: bohwaz, branch: trunk, size: 18440 [annotate] [blame] [check-ins using] [diff]
2020-12-05
14:02
Fix send mass message using custom search file: [5f2af851fc] check-in: [ac7e2be8ca] user: bohwaz, branch: dev, size: 17697 [annotate] [blame] [check-ins using] [diff]
2020-11-25
16:06
Add ability to search accounting using accounts and analytical file: [c748f37f3f] check-in: [3abc5388d1] user: bohwaz, branch: dev, size: 17673 [annotate] [blame] [check-ins using] [diff]
2020-11-11
23:55
Implement search copy [828073415a] file: [df28230a8c] check-in: [0f30454117] user: bohwaz, branch: dev, size: 17027 [annotate] [blame] [check-ins using] [diff]
2020-11-06
02:07
Migrate from userSelect to protectSelect file: [a6f9ee8488] check-in: [ca82a8d95a] user: bohwaz, branch: dev, size: 16764 [annotate] [blame] [check-ins using] [diff]
2020-10-25
01:40
Fix quick search file: [545f6e8a04] check-in: [65756d7fb3] user: bohwaz, branch: dev, size: 16471 [annotate] [blame] [check-ins using] [diff]
2020-10-24
20:07
Improve usability in search, add navigation tabs where suitable file: [c9e3680fb2] check-in: [42209a847b] user: bohwaz, branch: dev, size: 16427 [annotate] [blame] [check-ins using] [diff]
00:36
Implement accounting transaction search file: [fd1b7ac010] check-in: [f191ca0575] user: bohwaz, branch: dev, size: 16427 [annotate] [blame] [check-ins using] [diff]
2020-10-23
18:13
Refactor user search before extending it to accounting file: [130e7daf82] check-in: [4679f7092f] user: bohwaz, branch: dev, size: 12770 [annotate] [blame] [check-ins using] [diff]
2020-09-29
16:53
Move query building logic in class for quick member search file: [7025716f58] check-in: [1b4976cf19] user: bohwaz, branch: dev, size: 12497 [annotate] [blame] [check-ins using] [diff]
2020-09-03
16:20
Fix: remplacement de méta caractères file: [b656e7a9fd] check-in: [4b12667981] user: bohwaz, branch: dev, size: 11572 [annotate] [blame] [check-ins using] [diff]
2019-11-13
12:25
Permettre de rechercher les champs NULL même si obligatoire, car ils peuvent être restés NULL suite à changement de config de la fiche membre file: [98002e1aea] check-in: [5a76928d51] user: bohwaz, branch: trunk, size: 11568 [annotate] [blame] [check-ins using] [diff]
2019-02-22
10:17
Ne pas limiter les requêtes pour l'envoi de mail, et préciser clairement si la requête ne permet pas d'accéder aux colonnes nécessaires file: [35a5a3057c] check-in: [b13b9efbee] user: bohwaz, branch: trunk, size: 11597 [annotate] [blame] [check-ins using] [diff]
2018-12-18
13:49
Utiliser DB::userSelect* pour les requêtes en lecture file: [0325ea49c7] check-in: [836495093b] user: bohwaz, branch: trunk, size: 11286 [annotate] [blame] [check-ins using] [diff]
2018-10-25
11:25
Ajouter la colonne de tri dans les colonnes affichées, fix [0a59dffc92c5566e334ab0100a703801fd2c235f] file: [0f45eebdb7] check-in: [99a7c5c699] user: bohwaz, branch: dev, size: 11561 [annotate] [blame] [check-ins using] [diff]
10:56
Fix [9afefc9f2b6b1f4b] : permettre de chercher les champs nuls / non-nuls file: [a738c3a98e] check-in: [fd31435777] user: bohwaz, branch: dev, size: 11532 [annotate] [blame] [check-ins using] [diff]
10:38
Fix [9afefc9f2b6b1f4b7d07949e92c66e1604b19d37] Champs de type sélection unique : recherche non fonctionnelle file: [d3b4fbf0f1] check-in: [222a7d057f] user: bohwaz, branch: dev, size: 11358 [annotate] [blame] [check-ins using] [diff]
2018-10-19
19:33
Intercepter les recherches où rien n'a été sélectionné file: [1fb44b301a] check-in: [9c5436a829] user: bohwaz, branch: dev, size: 11325 [annotate] [blame] [check-ins using] [diff]
2018-10-09
16:50
Rejeter les recherches invalides file: [330b3b6bc8] check-in: [ef3a17cedd] user: bohwaz, branch: dev, size: 11214 [annotate] [blame] [check-ins using] [diff]
16:46
Création d'une recherche par défaut à l'installation file: [4a862884ec] check-in: [96bf857cc1] user: bohwaz, branch: dev, size: 11097 [annotate] [blame] [check-ins using] [diff]
2018-10-05
17:17
Forcer le select de l'ID et de l'email pour l'envoi de message file: [731bbdf536] check-in: [6a673f4813] user: bohwaz, branch: dev, size: 11103 [annotate] [blame] [check-ins using] [diff]
2018-10-03
11:34
Uniformisation des actions en bas des listes de membres file: [aac01b2fe7] check-in: [ec3640ce30] user: bohwaz, branch: dev, size: 10647 [annotate] [blame] [check-ins using] [diff]
2018-10-01
17:36
Ajout recherche sur catégorie de membre file: [7584e020e0] check-in: [b648e8d1ff] user: bohwaz, branch: dev, size: 10612 [annotate] [blame] [check-ins using] [diff]
17:14
Édition et suppression de recherche enregistrée file: [1c1828c11f] check-in: [a4991057b3] user: bohwaz, branch: dev, size: 10305 [annotate] [blame] [check-ins using] [diff]
2018-09-27
14:52
Enregistrement / modification / liste de recherches enregistrées file: [ae6601ff1c] check-in: [769382af32] user: bohwaz, branch: dev, size: 10287 [annotate] [blame] [check-ins using] [diff]
2018-09-20
18:37
Added: Déplacement des méthodes de recherche dans une classe à part, et les rendre un peu plus génériques pour permettre d'utiliser avec la recherche en compta, début de la gestion de sauvegarde de recherche file: [5a3bd60873] check-in: [d3efd06ccb] user: bohwaz, branch: dev, size: 9721 [annotate] [blame] [check-ins using]