[Devel] [GIT] OpenBioMaps GIT repository, branch master updated: custom reports as saved queries

Wed Apr 25 16:27:32 CEST 2018

    The project "OpenBioMaps GIT repository":

    The branch, master has been updated
       via  f00280e9fd320b59476f42a1e3e616aeb9c406d6 (commit)
       via  7229bc9627c977414b7ec80ad77f5c315e9eee4a (commit)
      from  4eab384d2eeb96c46333802ed5a127410c76b478 (commit)

- Log -----------------------------------------------------------------
commit f00280e9fd320b59476f42a1e3e616aeb9c406d6
Author: Bán Miklós <banm at vocs.unideb.hu>
Date:   Wed Apr 25 16:23:57 2018 +0200

custom reports as saved queries

I've added a new option - save queries and renamed the the existing
saved queries to saved results.

The saved query store the query string only, and can perform the query
as ?report=...

I've extended the custom_report table with 2 columns:
CREATE TABLE custom_reports (
id integer NOT NULL,
command text NOT NULL,
user_id integer NOT NULL,
key character varying(32),
project character varying(64),
query_string text
);
ALTER TABLE ONLY custom_reports
ADD CONSTRAINT custom_report_project_fkey FOREIGN KEY (project) REFERENCES projects(project_table) ON UPDATE CASCADE ON DELETE CASCADE;

commit 7229bc9627c977414b7ec80ad77f5c315e9eee4a
Author: Bán Miklós <banm at vocs.unideb.hu>
Date:   Wed Apr 25 14:30:26 2018 +0200

query api improved

available URL commands are:
query
query_api
report

query example:
index.php?query=faj:Pica pica

query_api example:
index.php?query={"qids_...":"["..."]"}

report example:
index.php?report=cinke
where cinke is a label of a stroed query in the custom reports table

In this commit there some rows related to save_query improvements. There
will be an other commit with this new / old functions

-----------------------------------------------------------------------

Summary of changes:
 libs/afuncs.php                  |  19 ++++++-
 libs/common_pg_funcs.php         | 106 +++++++++++++++++++++++++++++++++++----
 libs/css/style.css               |   8 +--
 libs/interface.php               |  43 ++++++++++++----
 libs/js/admin.js                 |  38 ++++++++++++++
 libs/js/main.js                  |  17 +++----
 libs/js/maps.js                  |  11 ++--
 libs/languages/en.php            |   4 ++
 libs/languages/hu.php            |   4 ++
 libs/languages/ro.php            |   4 ++
 libs/modules/box_filter.php      |  14 +++++-
 libs/modules/identify_point.php  |  50 ++----------------
 libs/modules/results_buttons.php |   5 +-
 libs/prepare_vars.php            |   5 +-
 libs/profile.php                 |  18 ++++++-
 libs/query_builder.php           |  58 +++------------------
 libs/results_builder.php         |  39 +++-----------
 17 files changed, 271 insertions(+), 172 deletions(-)

-- 
OpenBioMaps GIT repository