Search found 292 matches

by jsetzer
2019-12-09 07:33
Forum: Getting Started
Topic: Using AppGini Filters + $options->QueryWhere = causes SQL syntax error?
Replies: 4
Views: 130

NARROW DOWN: Using AppGini Filters + $options->QueryWhere = causes SQL syntax error?

Hi peebee, I agree, it should work the way you did it. Looks perfect. For narrowing down, I recommend doing the following checks: Double check the letter-casing of jobs -table (lowercase) and of referred -column (lowercase) and and also of $options->QueryWhere (PascalCase) in jobs_init()-function Ch...
by jsetzer
2019-12-05 08:30
Forum: Getting Started
Topic: How do I: Filter, based on 2nd table?
Replies: 11
Views: 102

Re: How do I: Filter, based on 2nd table?

Yes, Olaf, it is not easy. I'm also using Session variables for that. If you just prepend the table name to the session variable, it should work when opening a different table, for example you could name your session variables like this: $_SESSION["myfilter_table1_column1"] = "123" $_SESSION["myfilt...
by jsetzer
2019-12-05 07:19
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Datepicker
Replies: 10
Views: 218

Date-Range Picker

PRO-Tipp for you AppGineers out there: If you need inputs for a period (from date - to date), just create two datetime -fields in AppGini, then call the following code in hooks/TABLENAME-dv.js : Code new AppGiniFields(["valid_from", "valid_to"]).toDatepicker("Valid from/to"); Output chrome_lX4BkSGbx...
by jsetzer
2019-12-05 06:31
Forum: Getting Started
Topic: How do I: Filter, based on 2nd table?
Replies: 11
Views: 102

Re: How do I: Filter, based on 2nd table?

But even at the first link the $options->QueryWhere property is missing. Sorry, I do not understand if there is still a problem or not: There is the documentation for the _init() -function and there is also the documentation for the $options -parameter. Some more links: https://forums.appgini.com/p...
by jsetzer
2019-12-05 06:25
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Setting the title dynamically in detail view
Replies: 2
Views: 73

Re: Setting the title dynamically in detail view

pilandros wrote:
2019-12-03 03:59
I need to set the "JS title variable" to have the contents from the mysql name field.
Can I have an example?
Hi,

do you really need a value from MySQL which is NOT part of your form? Or does your form already contain that value?

Best,
Jan
by jsetzer
2019-12-04 16:15
Forum: Getting Started
Topic: How do I: Filter, based on 2nd table?
Replies: 11
Views: 102

Re: How do I: Filter, based on 2nd table?

Hi Olaf,

docs are available online:

https://bigprof.com/appgini/help/advanc ... ename_init
https://bigprof.com/appgini/help/advanc ... ist-object

The SQL Query usually already contains all joins for each and every modeled lookup.

Jan
by jsetzer
2019-12-04 13:37
Forum: Getting Started
Topic: How do I: Filter, based on 2nd table?
Replies: 11
Views: 102

Re: How do I: Filter, based on 2nd table?

Hi Olaf,
did you see the $options->QueryWhere property in TABLENAME_init()-function?
Best,
Jan
by jsetzer
2019-12-04 13:12
Forum: Getting Started
Topic: BLOB datatype
Replies: 6
Views: 74

Re: BLOB datatype

This is not a trivial task: After Insert/Update, as pböttcher has mentioned a minute ago, you will have to read all bytes from uploaded image, then insert/update the BLOB field bytewise using SQL. Afterwards you can delete the file from disk to reduce required space. You will need two fields in you ...
by jsetzer
2019-12-02 17:27
Forum: Getting Started
Topic: AppGini Helper JavaScript Library
Replies: 29
Views: 2286

Re: AppGini Helper JavaScript Library

Dear customers, there are several ways to get to know about updates . Right now you can... subscribe to the AppGini Lib subforum: https://forums.appgini.com/phpbb/viewforum.php?f=13 There is a separate thread for releases here: https://forums.appgini.com/phpbb/viewtopic.php?f=13&t=3329 Regularly vis...
by jsetzer
2019-11-30 21:38
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Releases
Replies: 6
Views: 168

Re: Releases

Hi, I'm sorry for any inconvenience you had with the download. I have just sent download-links to both of you. Latest version by now is Version 2019.11.27 Created 27.11.2019 00:11:40 I have just double-checked that the latest version on fastspring download platform is correct I have also double-chec...
by jsetzer
2019-11-29 14:59
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Releases
Replies: 6
Views: 168

Re: Releases

AppGini Helper Javascript Library
Version 2019.11.27
Created 27.11.2019 00:11:40

2019/11/26
- fix: AppGiniHelper client side js library expected a server side php script which is non-existant in customer's environment. Removed ajax call for that server side php script.
by jsetzer
2019-11-29 06:21
Forum: Getting Started
Topic: How to? Not focus first field in details view?
Replies: 4
Views: 84

Re: How to? Not focus first field in details view?

You are right, I was afraid there is something like this inside for a while now. Please try to disable AppGini's default behaviour with the following javascript code in TABLENAME-dv.js : AppGini.focusFirstFormElement = function() { /*noop*/ }; You should be able to implement your own focus-function ...
by jsetzer
2019-11-28 17:49
Forum: Getting Started
Topic: How to? Not focus first field in details view?
Replies: 4
Views: 84

Re: How to? Not focus first field in details view?

On document ready call the focus() method like $j("#fieldname").focus();

This will work for normal input fields if they already have been rendered.

But there may be some built in function doing the same for the first field a little bit later.
by jsetzer
2019-11-28 14:34
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Datepicker
Replies: 10
Views: 218

Re: Datepicker

Yes, I have just checked the underlying moment.js library and your locale should be "it".

Code: Select all

new AppGiniField("duedate").toDatepicker('it');
This is the datepicker with Italian UI:
chrome_V2wlAFO5yM.png
chrome_V2wlAFO5yM.png (12.98 KiB) Viewed 132 times

Please also have a look at your project settings:

AppGini_wL1ILiNTO8.png
AppGini_wL1ILiNTO8.png (5.22 KiB) Viewed 132 times
by jsetzer
2019-11-28 12:26
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Datepicker
Replies: 10
Views: 218

Re: Datepicker

That's right. The code will use the locale setting as it has been configured in your AppGini project. Anyway, you can pass a different locale as first argument (string) to the .toDatepicker method. But be careful: the value has to be converted and stored in your datetime database field. Both formats...
by jsetzer
2019-11-27 21:59
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Datepicker
Replies: 10
Views: 218

Re: Datepicker

sorry, I asked a stupid question, it's obvious that it's 2019-11-20 00:00:00. but if we need to display only the date in table-view? I have updated the documentation. There is a short description of how to change the data format in table view. https://appgini.bizzworxx.de/products/javascript-librar...
by jsetzer
2019-11-27 20:31
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Datepicker
Replies: 10
Views: 218

Re: Datepicker

It's not a stupid question at all, thank you for pointing that out! You can format your table view values in "Data format" in the field properties: AppGini_a0W6ORcBND.png If there is no suitable format inside the list, feel free to create your custom format. AppGini_qcQ5TEFftA.png Best, Jan
by jsetzer
2019-11-27 20:19
Forum: Tips And Tricks
Topic: data entry in table view
Replies: 7
Views: 2724

Re: data entry in table view

This is my personal opinion only Although I can understand your request for editable tables and really would like to have this option myself, I guess there is a very good reason why noone has ever posted a good hook-only solution: It is very complicated :!: Whoever makes up his/her mind about this ...
by jsetzer
2019-11-27 15:27
Forum: Getting Started
Topic: AppGini Helper JavaScript Library
Replies: 29
Views: 2286

Re: AppGini Helper JavaScript Library

I have sent a PM to you.
by jsetzer
2019-11-27 08:11
Forum: Getting Started
Topic: Date picker style and dates allowed
Replies: 6
Views: 2973

Re: Date picker style and dates allowed

Maybe this information will help:
viewtopic.php?f=13&t=3331#p11581
by jsetzer
2019-11-27 08:10
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Datepicker
Replies: 10
Views: 218

Datepicker

If you wish to turn the default date picker (3 selects + 1 button) ... ... into a single line datepicker ... chrome_AdK7kmILkc.png ... with only one line of javascript code ... // file: hooks/TABLENAME-dv.js new AppGiniField("duedate").toDatepicker(); ... you should have a look here: https://appgini...
by jsetzer
2019-11-26 15:11
Forum: Getting Started
Topic: AppGini Helper JavaScript Library
Replies: 29
Views: 2286

Re: AppGini Helper JavaScript Library

Hi AppGineers out there, there are so many news today: New Homepage AppGini Helper Library has found a new home now: https://appgini.bizzworxx.de/ Please update your bookmarks! New Release We have released new version today. See the release information here: https://forums.appgini.com/phpbb/viewtopi...
by jsetzer
2019-11-26 13:23
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: Releases
Replies: 6
Views: 168

Releases

AppGini Helper JavaScript Library Version 2019.11.26 Created 26.11.2019 08:23:53 Highlights: Custom Tabs in detail view https://appgini.bizzworxx.de/products/javascript-library/documentation/detail-view/tabs/ Expandable/Collapsible Layout Rows in detail view https://appgini.bizzworxx.de/products/jav...
by jsetzer
2019-11-21 20:36
Forum: Tips And Tricks
Topic: Modifying CSS panel-body
Replies: 8
Views: 552

Re: Modifying CSS panel-body

Much better now, well done!
by jsetzer
2019-11-20 17:54
Forum: Bugs/annoyances
Topic: Uploaded files are not saved from deletion and not unique
Replies: 4
Views: 121

Re: Uploaded files are not saved from deletion and not unique

Hi Olaf, if you need the file's original filename, you should have a look at PHP's $_FILES array. If there is need for some custom filename-changing, you can have a closer look at the PrepareUploadedFile function in incCommon.php . You can copy that code as a base and write your own function. As you...