History of the file that is called src/include/lib/Garradin/Recherche.php at checkin 0f3045411765df3e
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] | |