dr-eberle-zentrum/dbwebgen

Database Web Forms Generator

dbwebgen's Issues

caching of stored query visualizations

built-in form validation for N:M tables with additional required fields

In n:m tables that are linked via T_LOOKUP/CARDINALITY_MULTIPLE fields, the linkage table might have additional required fields. Currently this can only be discovered through knowing or through the error raised when saving the record. Form validation should be built in for all linkage tables that have required fields which do not have a default values specified in the settings.

Password reset function

We need a function that allows users that submited an email to reset the password via that email adress

enable display of null fields

... when the null field display is disabled

Validation support. date data type support

The original issue is below but now I believe THERE must exist user-defined validation function!!! Such function should check field values and prevent form from submitting with error popup
Isn't it possible to implement drop down calendar and corresponding datatype/field type? Thank you very much for your great project I'd donate if I had money...

Enable merging of records

Allow user to initiate merging of any two records in a table (along with their "dependencies" established by lookup fields)

when editing an upload field, allow to leave file empty

... this allows users to edit e.g. image properties withouth having to reupload the original image.

dynamic loading of looking fields: use search_string_transformation setting

"search_string_transformation" setting should be used for comparing T_LOOKUP async lookups

Problem with order of numeric values in queries.

Hello.
First, congratulations for your great work! An excellent tool to manage queries in a database!!
I use your tool to make many queries, and store that.
But when I get the result, and try to order pressing in the heading of the column, the numeric column values dont get ordered.
If there are two values, for example, 234 and 1234, the app get first 1234 than 234.
It work with the numbers as strings: the "1" before the "2", not the 234 before the 1234.
Can I correct that in any way?
Thanks!

"Create New" result in all dropdowns of same entity type

In MODE_NEW, each "Create New" button adds the resulting record only to the dropdown box to which the button is attached. All other dropdowns with the same linked entity type should be updated as well.

Upload visualisation

Whenever an upload is performed the browser sgouldn't freeze and instead visual feedback should be displayed; e.g. a moving hourglass.

npm install warnings

npm WARN deprecated [email protected]: This module is now under the @mapbox namespace: install @mapbox/leaflet-omnivore instead
npm WARN deprecated [email protected]: This module has moved: please install @mapbox/togeojson instead
npm WARN deprecated [email protected]: This module is now under the @mapbox namespace: install @mapbox/corslite instead
npm WARN deprecated [email protected]: This module is now under the @mapbox namespace: install @mapbox/polyline instead
npm WARN deprecated [email protected]: Use topojson-client, topojson-server or topojson-simplify directly.
npm WARN deprecated [email protected]: This module is now under the @mapbox namespace: install @mapbox/sexagesimal instead
npm WARN deprecated [email protected]: Please consider using https://github.com/visjs
npm WARN deprecated [email protected]: Replaced by d3-dsv.
npm WARN deprecated [email protected]: renamed to d3-queue

npm WARN [email protected] requires a peer of jQuery@>=1.8 but none is installed. You must install peer dependencies yourself.
npm WARN [email protected] requires a peer of component-emitter@^1.3.0 but none is installed. You must install peer dependencies yourself.
npm WARN [email protected] requires a peer of hammerjs@^2.0.0 but none is installed. You must install peer dependencies yourself.
npm WARN [email protected] requires a peer of keycharm@^0.2.0 || ^0.3.0 but none is installed. You must install peer dependencies yourself.
npm WARN [email protected] requires a peer of propagating-hammerjs@^1.4.0 but none is installed. You must install peer dependencies yourself.
npm WARN [email protected] requires a peer of vis-data@^6.2.0 but none is installed. You must install peer dependencies yourself.
npm WARN [email protected] requires a peer of vis-util@^3.0.0 but none is installed. You must install peer dependencies yourself.

Charts & SQL query box

Apologies if I'm missing something obvious but my installation displays list of records fine and I can search on columns, edit & add records but I can't see any way to access the SQL query box or the charts shown in the screenshots.

Do I need to write some plug-ins in PHP?

parameterized queries

allow parameterized queries in MODE_QUERY. viewer may select values for the parameters when displaying visualization of query result

Reversed 1:N relationship missing

Right now we have 1:N (T_LOOKUP with CARDINALITY_SINGLE) and N:M (T_LOOKUP with CARDINALITY_MULTIPLE). We lack some kind of a N:1 (a reversed 1:N) relationship.

Example: brand 1:N model. Right now it is possible to use a 1:N lookup in model and assign the brand to the model. In many cases, e.g. to reduce the form editing effort, it makes sense to allow assigning models to brands in the brand editing form. Supporting this should be possible in dbWebGen

Pre-Displayed default value for textfields

Hi,

we need a method for the following situation: We want to add a default-value for T_TEXT_LINE. This value should be displayed when the site is requested by a user within the corresponding text-field.

Cheerz,

Kevin

add default caching behavior for query visualizations

Search Function always returns no results

This looks like a great program that suits my needs well but I'm finding that all searches return null results. I have columns of various types - text, fixed length characters and boolean, but all searches return no results. My postgres log shows lines like:
2019-04-10 19:25:00.539 BST [3831] postgres@cases ERROR: could not determine data type of parameter $1
2019-04-10 19:25:00.539 BST [3831] postgres@cases STATEMENT: SELECT COUNT(*) FROM "cases" d WHERE "full_text"::text like concat('%', $1, '%')

I'm using Firefox (but get same issues on Vivaldi) on ubuntu 18.04.02 on an oracle VM.
Postgres is v 10.7
PHP v7.3.3

Any help would be much appreciated

Icon-based Textfield-Value setting

We require a method for the following use-case:
Behind input-fields symbols may be displayed. Once a symbol is clicked by the user, the textfields value is set to a pre-defined value. E.g.: Symbol is "hammer and sickle" and value should by ´communism'.

bootstrap dependencies

Hi, I would like to know if you agree to include js and css in the project ?

Indeed, dbWebGen cannot render pages in 'offline' mode.
New directories /content should be used :

/dbWebGen/inc/bootstrap/js
bootstrap.min.js
jquery.min.js
select2.min.js
transliteration.min.js

/dbWebGen/inc/bootstrap/css
bootstrap.min.css
select2-bootstrap.css
select2.min.css
/dbWebGen/inc/fonts
glyphicons-halflings-regular.ttf
glyphicons-halflings-regular.woff
glyphicons-halflings-regular.woff2

Search-Function does not work properly

Searching related data does not work properly in n-m-relations

Page icon

Allow setting a custom page icon

limit results in dynamically loaded T_LOOKUP boxes

offer setting to limit returned results

T_ForeignKeyLookup not updated

When I display id (not "name" for example) in T_ForeignKeyLookup

'trip_id' =>
						array (
							'label' => 'Trip Id',
							'required' => true,
							'editable' => true,
							'type' => 'T_ForeignKeyLookup',
							'lookup' =>
								array (
									'cardinality' => 'CARDINALITY_SINGLE',
									'table' => 'trips',
									'field' => 'id',
									'display' => 'id',
									'label_display_expr_only' => true,
								),
						),

And when I create a new "trip" clicking near "Trip Id" field the dropdown IS NOT UPDATED and is not autosubstituted..
When I use for example

 'hotel_id' => 
      array (
        'label' => 'Hotel Id',
        'required' => true,
        'editable' => true,
        'type' => 'T_ForeignKeyLookup',
        'lookup' => 
        array (
          'cardinality' => 'CARDINALITY_SINGLE',
          'table' => 'hotels',
          'field' => 'id',
          'display' => 'name',
          'label_display_expr_only' => true,
        ),
      ),
    ),

So when I use 'display' => 'name', there is no such bug...
Why there is a bug with using 'display' => 'id', ?

Password modification missing

We need a function that allows common users to change their password within the application.

Dynamic loading of T_LOOKUP boxes

use select2 ajax functionality to dynamically populate dropdown box while typing

[PROPOSAL] Table view

Hello! This engine saved me a lot of time doing simple CRUD applications for our PostgreSQL instance. Overall it's pretty good, but I faced with one request I wasn't able to resolve. Table view. "Yeah, just like in Google Sheets, it would be way faster to insert a batch data here rather than in a form". Seems like a wise idea, so I am sharing it with you guys. Thanks for such a delightful solution for "hey, you kinda know computers, solve this" kind of people. ❤️

Bootstrap / popover bug

The bootstrap version used into package.json is version 3.4.1

This version is got an issue with popover widget. moving back to bootstrap 3.4.0 resolve the issue....

The clean way is to tune sanitizer rules.

Table managment rights

Isn't it possible to somehow restrict edit ability for some users for some tables? There is login functionality but no right management? Can it be implemmented by user? Maybe in login_success_proc I can define table rights depending on logged in user name?
I'll probably have write a separate php script which will after login

1. edit seetings.php of dbwebgen
2. open and pass login info to real dbwegen
   Or how do I allow certain users to see/edit certain tables For example
   user:Ivan{
   meals{view}
   hotels{view,edit}
   }
   user:maria{
   meals{view,edit}
   hotels{view}
   }

Mysql

Hi, is it compatible with mysql?
Thanks

confirm unsaved changed when navigating away from edit page

allow prefilled form fields in records created via field/lookup

something like

  'lookup' => [
    'predefined_values' => [
      'name' => 'Marl Calone', // e.g. for T_TEXT_LINE
      'locations' => '[2,19]', // e.g. for T_LOOKUP/CARDINALITY_MULTIPLE
      'age' => 9 // e.g. for T_NUMBER
    ]
  ]