[Devel] [GIT] OpenBioMaps GIT repository, branch custom-admin-pages updated: .
git at vocs.unideb.hu
git at vocs.unideb.hu
Tue Aug 28 09:46:38 CEST 2018
The project "OpenBioMaps GIT repository":
The branch, custom-admin-pages has been updated
via a41924e5b479ed54ca771f74e7429bb340e303b5 (commit)
via 97f3a759a011780144eb474ff559040aae51a8a0 (commit)
via fb7b2f9e49bcf8575aa8342693541d24fb9d1efa (commit)
via 46cd2932435ddc846161e060f4b0c28508bfa1a4 (commit)
via 9aa9aaf1439fdec93ff347f04ab2fe856e30e4d7 (commit)
via 14c0ec271d8a1899ff02f7dd455d3b642579da7e (commit)
via ea0431177a1cbbd88eb20771db00aafdadb4db24 (commit)
via 5d1639ff13ea4a3cf6bebe6c4ae822843bcdc691 (commit)
from fd5ba2fa45b59ff4b2a34ccbd396867265f6b644 (commit)
- Log -----------------------------------------------------------------
commit a41924e5b479ed54ca771f74e7429bb340e303b5
Author: Bóné Gábor <gabor.bone at milvus.ro>
Date: Tue Aug 28 10:46:01 2018 +0300
.
commit 97f3a759a011780144eb474ff559040aae51a8a0
Merge: fb7b2f9e fd5ba2fa
Author: Bóné Gábor <gabor.bone at milvus.ro>
Date: Tue Aug 28 10:45:18 2018 +0300
Merge branch 'custom-admin-pages' of vocs.unideb.hu:/home/git/openbiomaps into custom-admin-pages
commit fb7b2f9e49bcf8575aa8342693541d24fb9d1efa
Author: Bóné Gábor <gabor.bone at milvus.ro>
Date: Mon Aug 27 22:53:03 2018 +0300
error handling
commit 46cd2932435ddc846161e060f4b0c28508bfa1a4
Author: Bóné Gábor <gabor.bone at milvus.ro>
Date: Mon Aug 27 16:10:22 2018 +0300
custom admin pages
if a module has getMenuItem() and adminPage() public methods, returning
the menu label, url, and the admin page html, a new menu is created with
this module
commit 9aa9aaf1439fdec93ff347f04ab2fe856e30e4d7
Merge: 14c0ec27 32db2c5b
Author: Bán Miklós <banm at vocs.unideb.hu>
Date: Tue Aug 28 03:41:37 2018 +0200
Merge branch 'master' of vocsi:/home/git/openbiomaps
commit 14c0ec271d8a1899ff02f7dd455d3b642579da7e
Author: Bán Miklós <banm at vocs.unideb.hu>
Date: Tue Aug 28 02:35:21 2018 +0200
Fixes and updates
1) photo/attachment file_connect table
Update table:
ALTER TABLE file_connect ALTER COLUMN conid TYPE character varying(32);
ALTER TABLE file_connect ADD COLUMN temporal boolean DEFAULT true;
ALTER TABLE file_connect ADD COLUMN sessionid character varying(64);
ALTER TABLE file_connect ADD COLUMN rownum smallint;
In Data tables add a trigger:
CREATE TRIGGER file_connection AFTER INSERT ON dinpi FOR EACH ROW EXECUTE PROCEDURE file_connect_status_update();
file_connect_status_update
BEGIN
IF (TG_OP = 'INSERT' OR TG_OP = 'UPDATE') THEN
IF (new.obm_files_id IS NOT NULL) THEN
UPDATE file_connect SET temporal=false WHERE temporal=true AND conid=new.obm_files_id;
END IF;
RETURN new;
END IF;
END
This trigger and the 'temporal' column can prevent accidental deletion from file_connect if session id are not unique.
- duplicated conid problem fixed
- connections can be deleted or updated from phtomanage window
- file manager admin page was updated, but not ready. The table content was updated, but files can't be deleted or updated.
2)
autocomplete / create menu (SELECT DISTINCT ...) bug fixed
Default is using distinct without unique obm_id column but menu can be
create with the optional all_options='on' parameter and in this case
menu will be created without 'distinct'.
3)
speedup filter for improving auto created menus which uses SELECT
DISTINCT query. This filter can be useful for huge tables.
Add the obm_first_letter_filter column to these tables. E.g.
UPDATE kuvet_bevet_2018 SET obm_first_letter_filter=lower(substring(telepules from 1 for 1))
And it will be used in the queries in the following way:
OLD:
SELECT DISTINCT "telepules" "telepules" FROM hrsz_terkepek."kuvet_bevet_2018" WHERE CAST("telepules" AS TEXT) ILIKE 'bak%' ORDER BY telepules LIMIT 20
With speedup_filter:
SELECT DISTINCT "telepules" "telepules" FROM hrsz_terkepek."kuvet_bevet_2018" WHERE obm_first_letter_filter='b' AND CAST("telepules" AS TEXT) ILIKE 'bak%' ORDER BY telepules LIMIT 20
4)
text filter (and other box filter) menus can controlled by several
parameters. See the following examples and explanations.
modules/text_filter:
d.szamossag:nested(d.egyedszam):autocomplete
d.egyedszam:values():
Explanation of this example:
- The "d" letter will be resolved from the sql_query's alias, for
creating references for the JOIN-ed tables
- nested(x) means that the select menu's content for x column, will be created by the
user input in this field.
- autocomplete: means that the 'szamosság' field will not be
displayed as the usual multiselect input field but as an autocomplete field. Further parameter is
"singleselect".
- values() sets values for the field. In this case the select input field will be empty (It will be filled with filtered content based on user input in the box above it).
I have to write documentation, consistently and diligently ... Is there anybody can help me??? There are so many small and practical
non-documented features everywhere!!!
We should update the 'github.com/OpenBioMaps/documentation' page after create or update OBM features!!!
commit ea0431177a1cbbd88eb20771db00aafdadb4db24
Author: Bán Miklós <banm at vocs.unideb.hu>
Date: Fri Aug 24 18:55:22 2018 +0200
non defined index warning fix
this bug fix not a full solution for this problem because it just
eliminates the warnings without solving the background of this problem
commit 5d1639ff13ea4a3cf6bebe6c4ae822843bcdc691
Author: Bán Miklós <banm at vocs.unideb.hu>
Date: Fri Aug 24 18:54:19 2018 +0200
autocomplete list definition bug fix
-----------------------------------------------------------------------
Summary of changes:
.gitignore | 10 +-
libs/.afuncs.php.swk | Bin 0 -> 143360 bytes
libs/.common_pg_funcs.php.swi | Bin 0 -> 299008 bytes
libs/afuncs.php | 95 +++++++++----
libs/common_pg_funcs.php | 81 ++++++-----
libs/css/style.css | 2 +-
libs/interface.php | 2 +-
libs/js/admin.js | 74 +++++-----
libs/js/functions.js | 5 +-
libs/js/main.js | 17 +--
libs/js/maps.js | 53 ++++---
libs/js/uploader.js | 156 ++++++++++++---------
libs/modules/custom_admin_pages.php | 49 +++++--
libs/modules/results_asList.php | 2 +-
libs/photos.php | 1 -
libs/project_admin.php | 39 +++---
libs/update_fields.php | 16 ++-
libs/upload_funcs.php | 14 +-
pds/pds_class.php | 8 +-
.../initial/root/UMS_REPOSITORY/repository.db | 5 +
templates/initial/root/index.php | 7 +
21 files changed, 402 insertions(+), 234 deletions(-)
create mode 100644 libs/.afuncs.php.swk
create mode 100644 libs/.common_pg_funcs.php.swi
--
OpenBioMaps GIT repository
More information about the Devel
mailing list