Search found 1152 matches

by jsetzer
2021-09-26 17:19
Forum: Getting Started
Topic: unread or new records count on home page.
Replies: 5
Views: 107

Re: unread or new records count on home page.

Well done, @Olaf! Good idea using hooks/links-navmenu.php
by jsetzer
2021-09-26 06:55
Forum: Getting Started
Topic: unread or new records count on home page.
Replies: 5
Views: 107

Re: unread or new records count on home page.

I forgot: when deleting a record you will have to delete all related views, too. Otherwise calculation will be wrong.
by jsetzer
2021-09-26 06:47
Forum: Getting Started
Topic: unread or new records count on home page.
Replies: 5
Views: 107

Re: unread or new records count on home page.

AppGini stores when a record was created and last updated but not when viewed by whom. So, first you will have to save whenever a user views a record. A good place for this is TABLENAME_dv hook. Create a table record_views with columns id, tableName, pkValue, memberID (²). In _dv hook, if selectedID...
by jsetzer
2021-09-15 17:45
Forum: Getting Started
Topic: Enable Search on Subgrids?
Replies: 3
Views: 78

Re: Enable Search on Subgrids?

Well, in-page search would not be too complicated to implement, but searching across all (!) sub-records (not only the 10 visible records) will indeed be much much work.
by jsetzer
2021-09-13 12:23
Forum: Bugs/annoyances
Topic: appgini_query_log table???
Replies: 11
Views: 579

Re: appgini_query_log table???

In my environment there are about 15 new entries per login. I have added a small piece of code for automatically deleting logged error messages older than 1 day. This should keep the table small. You can put something like this for example to login_ok() -function in hooks/__global.php // file: hooks...
by jsetzer
2021-09-13 11:47
Forum: Bugs/annoyances
Topic: appgini_query_log table???
Replies: 11
Views: 579

Re: appgini_query_log table???

I can confirm this: I also get errors after logging in. I have already sent a change request for not-logging avoidable errors (like errors on creating indexes which already exist) and feature requests for delete-all and delete buttons in admin backend to Ahmed a couple of days ago. Let's hope the am...
by jsetzer
2021-09-10 05:06
Forum: Bugs/annoyances
Topic: appgini_query_log table???
Replies: 11
Views: 579

Re: appgini_query_log table???

There are two kinds of log-entries: Errors Errors in SQL query or outdated database schema (difference(s) between configured model and actual database schema). Those will have an error message in "error" column. Slow SQL queries SQL queries which require more than 1.0 seconds for execution. Those sh...
by jsetzer
2021-08-31 17:36
Forum: Getting Started
Topic: FORMAT() Not Working in Calculated Field
Replies: 4
Views: 176

Re: FORMAT() Not Working in Calculated Field

What is the datatype? If you convert a number to a string by using SQL format functions this can not be stored in a numeric field. So you have to decide if you need the numeric value or a language dependent string presentation of the value. You may consider adding a second field: keep the numeric fi...
by jsetzer
2021-08-27 04:40
Forum: Tips And Tricks
Topic: Remove duplicates in Array
Replies: 3
Views: 138

Re: Remove duplicates in Array

I guess there will be one or more fields in $row which you can use for detecting duplicates. There are different ways to achieve this. Those came into my mind at first: PHP (1): Before adding $row to $has_cont array, check if $has_cont already contains an item having the same field values. Useful fu...
by jsetzer
2021-08-26 18:40
Forum: Advanced Customizations > Hooks
Topic: Learning to use hooks
Replies: 6
Views: 220

Re: Learning to use hooks

(3) there are many different ways starting from $_GET or $_POST parameters via $_SESSION variables up to database storage. It really depends on your specific scenario and requirements. Maybe you should specify what exactly you want.
by jsetzer
2021-08-26 18:37
Forum: Advanced Customizations > Hooks
Topic: Learning to use hooks
Replies: 6
Views: 220

Re: Learning to use hooks

I think echoing a string will not have any effect here, because after insert process appgini will redirect to another page and the script command will not be passed over into the follow-up page.

Try

Code: Select all

var_dump("Test"); 
exit();
by jsetzer
2021-08-26 18:33
Forum: Advanced Customizations > Hooks
Topic: Learning to use hooks
Replies: 6
Views: 220

Re: Learning to use hooks

hooks/duck-season-2015.php
Shouldn't it be duck_season_2015.php with underscores instead of hyphens?
by jsetzer
2021-08-22 20:39
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Is there a way to remove the Admin Information ?
Replies: 2
Views: 89

Re: Is there a way to remove the Admin Information ?

Well, it is only visible for admin user and not for other users.

There is no function for hiding it, yet, but I can add this feature to next version.
by jsetzer
2021-08-22 20:37
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Is there a way to remove the Table Name?
Replies: 2
Views: 91

Re: Is there a way to remove the Table Name?

I think there isn't, but I can add this feature to next version. I'm just wondering what shall happen to the add-new button
by jsetzer
2021-08-20 22:15
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Next / Prev. Navigation in DV
Replies: 13
Views: 821

Re: Next / Prev. Navigation in DV

As far as I can see AppGiniHelper.DV.ActionButtons()
.hideText(); has nothing to do with hiding prev/next buttons
by jsetzer
2021-08-18 16:49
Forum: Advanced Customizations > Others
Topic: Ticketing system - harvest emails from IMAP account
Replies: 1
Views: 116

Re: Ticketing system - harvest emails from IMAP account

Is this a possibility with AG ? Yes, it is possible. I have recently programmed an IMAP interface using PHPs imap_* functions for reading UNSEEN emails in different subfolders of INBOX, parsing contents and importing parsed data into an AppGini table. I cannot post the code here, but you can PM me ...
by jsetzer
2021-08-18 11:27
Forum: Bugs/annoyances
Topic: appgini_query_log table???
Replies: 11
Views: 579

Re: appgini_query_log table???

Hi, I did a short research and I can confirm the problem. I have found the reason and a interim -solution which I have just emailed to Ahmed, hoping for a fast patch. I am going to explain the problem and provide a hotfix in here: Hotfix for 5.97 Important: This hotfix will be overwritten :!: on nex...
by jsetzer
2021-08-16 13:14
Forum: Getting Started
Topic: Drop-down-list
Replies: 1
Views: 159

Re: Drop-down-list

Maybe auto creating a TABLENAME.FIELDNAME.csv file in hooks directory can help?

If you know the free numbers, you could create such a file like:

Code: Select all

1;;2;;4;;5;;6;;10
by jsetzer
2021-08-13 18:00
Forum: Getting Started
Topic: field in parent from child
Replies: 3
Views: 178

Re: field in parent from child

Check the quotes surrounding Nachname and also Spindbelegung. Those should be backticks, not single quotes
by jsetzer
2021-08-13 15:22
Forum: Getting Started
Topic: field in parent from child
Replies: 3
Views: 178

Re: field in parent from child

Yes, for example by creating a calculated field in master table and using SQL to fetch any information from any other database table. You can use placeholder %ID% as primary key of master record in your SQL queries
by jsetzer
2021-08-08 17:30
Forum: Getting Started
Topic: empty record
Replies: 6
Views: 253

Re: empty record

As I said: usually you don't use the technical id for naming (numbering) a given number (=100) of records. Anyway, if you don't want them to delete or create records, you will have to use filters for listing only lockers not having an owner. Then they can select one record in DV, then press an extra...
by jsetzer
2021-08-08 11:29
Forum: Getting Started
Topic: empty record
Replies: 6
Views: 253

Re: empty record

By the way: I'm not sure if I got it right. Are you relying on 'id' column for locker-number 1-100? Usually you don't care for the technical id (primary key column) but create a second column, for example 'number', which can contain numbers 1-100 or more. Having technical id separate from number, yo...
by jsetzer
2021-08-08 11:20
Forum: Getting Started
Topic: empty record
Replies: 6
Views: 253

Re: empty record

What about an additional status field?

Like occupied yes/no (boolean) or status (free/occupied/reserved/...) or status_id as lookup refering a second 'states' table.

There are many options depending on your specific requirements.
by jsetzer
2021-07-29 19:55
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Next / Prev. Navigation in DV
Replies: 13
Views: 821

Re: Next / Prev. Navigation in DV

Explanation; When loading a webpage dozens to hundreds of single resources are loaded. Due to internet architecture there is no guarantee for a certain order of loading nor can be guaranteed that specific lazy loaded resources are available when the main page has been downloaded completely. Before a...
by jsetzer
2021-07-29 19:43
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Releases
Replies: 19
Views: 5762

Re: Releases

SOLVED by email