Search found 1165 matches

by jsetzer
2021-10-26 12:20
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: AppGiniHelper InlineDetailView Plugin 20191219-01 does not work with AppGini 5.94
Replies: 11
Views: 914

Re: AppGiniHelper InlineDetailView Plugin 20191219-01 does not work with AppGini 5.94

Hi, thanks for the detailed report.

Can you please check for any errors in console, first, which may break script execution.

Then, please send your ordernumber to [email protected]. Gonna send a download link for latest version to you.
by jsetzer
2021-10-14 10:22
Forum: Advanced Customizations > Others
Topic: Hide/Show columns with #toggle-columns-container
Replies: 5
Views: 181

Re: Hide/Show columns with #toggle-columns-container

I wanted to share a screenshot but wasn't able to edit the previous post. So here it is.
by jsetzer
2021-10-14 10:10
Forum: Advanced Customizations > Others
Topic: Hide/Show columns with #toggle-columns-container
Replies: 5
Views: 181

Re: Hide/Show columns with #toggle-columns-container

Check localstorage in your Browser. You should be able to write default values per table for example when user enters site and no TV column settings have been stored, yet. There are entries name like this: columns-TABLENAME_view . Those entries (JSON-encoded string) contain all field names as proper...
by jsetzer
2021-10-13 10:11
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Problem with AppGiniHelper v2021.07.29
Replies: 8
Views: 284

Re: Problem with AppGiniHelper v2021.07.29

Your code I have only added the missing square brackets und removed empty lines var dv = AppGiniHelper.DV; dv.addGroup("grp_ambient", "Improvement", ["corrective_action", "emergency"], Variation.primary); dv.addGroup("grp_riskop", "Risks", ["risks", "opportunity"], Variation.primary); var info= new...
by jsetzer
2021-10-13 09:04
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Problem with AppGiniHelper v2021.07.29
Replies: 8
Views: 284

Re: Problem with AppGiniHelper v2021.07.29

I am going to check this today. Stay tuned.

Are there more errors in console than the one I can see above? Did you disable caching or reloaded browser page without cache?
by jsetzer
2021-10-13 09:01
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: React to lookup question
Replies: 2
Views: 155

Re: React to lookup question

Interesting idea. First, hide all but the first using .hide() method. Next, register onChange handler for all lookups In each onChange event handler, check the value using .getValue method. Then hide or show the next lookup. It may become more difficult when opening existing records having values al...
by jsetzer
2021-10-13 04:04
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Nested Tabs
Replies: 3
Views: 105

Re: Nested Tabs

Sorry, the library does not have any built-in functions for nesting custom tabs in custom tabs. You will have to code this using jQuery for example. If you need structured layout within a custom tab perhaps collapsible panels can help: https://appgini.bizzworxx.de/products/javascript-library/documen...
by jsetzer
2021-10-12 12:29
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Nested Tabs
Replies: 3
Views: 105

Re: Nested Tabs

I am not 100% sure about what you mean by nested tabs, because I haven't seen it for Bootstrap 3 with full browser- and OS- compatibility, yet. AGH JS library does only provide functions for building custom tabs but not for nesting custom tabs in custom tabs. But I think it may be possible using add...
by jsetzer
2021-10-12 05:53
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Problem with AppGiniHelper v2021.07.29
Replies: 8
Views: 284

Re: Problem with AppGiniHelper v2021.07.29

.add(1, [ "grp_contimp", "grp_riskop");
There is closing square bracket missing ].

Don't know if this is the reason, but please fix and report back.
by jsetzer
2021-10-11 19:24
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Problem with AppGiniHelper v2021.07.29
Replies: 8
Views: 284

Re: Problem with AppGiniHelper v2021.07.29

Sorry for the problem. I did not get any bugreport before, but I am going to check this on Wednesday.
by jsetzer
2021-10-07 05:33
Forum: Getting Started
Topic: auto insert query in function table_init()
Replies: 5
Views: 195

Re: auto insert query in function table_init()

amyat wrote:
2021-10-06 06:04
how to write insert query in function _init()

Code: Select all

$sql = "YOUR SQL COMMAND HERE";
$error = null;
sql($sql, $error);
if ($error) die($error);
by jsetzer
2021-10-06 05:54
Forum: Getting Started
Topic: auto insert query in function table_init()
Replies: 5
Views: 195

Re: auto insert query in function table_init()

If table name equals "debit" then filename should be hooks/debit.php, not hooks/table.php

Did you check your SQL command in your SQL tool (like phpMyAdmin or Adminer)?

Is there a reason why you are not using AppGini's built-in function sql("...", $error)?
by jsetzer
2021-10-04 22:10
Forum: Advanced Customizations > Hooks
Topic: How Can I make the Box of Fields Wider in Detail View Page?
Replies: 4
Views: 375

Re: How Can I make the Box of Fields Wider in Detail View Page?

Code: Select all

<script>
$j(document).ready(function(){
  $j('.container').toggleClass('.container .container-fluid');
});
</script>
by jsetzer
2021-09-26 17:19
Forum: Getting Started
Topic: unread or new records count on home page.
Replies: 5
Views: 300

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: 300

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: 300

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: 158

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: 13
Views: 931

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: 13
Views: 931

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: 13
Views: 931

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: 286

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: 218

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: 330

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: 330

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: 330

Re: Learning to use hooks

hooks/duck-season-2015.php
Shouldn't it be duck_season_2015.php with underscores instead of hyphens?