Search found 257 matches

by jsetzer
2019-10-08 17:46
Forum: Tips And Tricks
Topic: Edit one or more table fields from the TV
Replies: 3
Views: 50

Re: Edit one or more table fields from the TV

Final result: <img src="PATH_TO_IMAGE" /> Use the concat function of SQL to concatenate the first part + the image path + the last part. Something like concat( '<img src="', imagepathfieldname, '" />') Sorry, I'm on holiday and typing on the phone. There may be typos, but it should poibt you into a ...
by jsetzer
2019-10-08 16:24
Forum: Tips And Tricks
Topic: Edit one or more table fields from the TV
Replies: 3
Views: 50

Re: Edit one or more table fields from the TV

Yes, have a look at HTML's content editable attributes. And you will need AJAX on client-side (browser) to send edited values and some PHP on server-side to retrieve the new values, check permissions and store the data.

Best,
Jan
by jsetzer
2019-10-08 16:23
Forum: Getting Started
Topic: show image from url
Replies: 6
Views: 98

Re: show image from url

You should have a look at the new SQL Query feature of 5.80. You should be able to use the SQL concat() function to concat a valid <img>-Tag including the src="" attribute.

Just an idea.
Best,
Jan
by jsetzer
2019-10-07 17:22
Forum: Advanced Customizations > Hooks
Topic: Modify the original DV SQL
Replies: 15
Views: 161

Re: Modify the original DV SQL

Do you really mean "detail view"? Or do you want to restrict the visible records in table-view?

Maybe you can do additional auth checks in _dv function of hooks/TABLENAME.php and perhaps redirect the user conditionally.
Best
Jan
by jsetzer
2019-10-03 10:30
Forum: Getting Started
Topic: AppGini Helper JavaScript Library
Replies: 17
Views: 763

NEW VERSION: AppGini Helper JavaScript Library (2019/10/03-01)

Good morning everyone, I hereby announce that a new version (2019/10/03) of our AppGini Helper JavaScript Library is available now. Highlights Expandable/Collapsible Panels for your detail view forms, auto-saving state. Change title of detail view form (text and/or html) Replace home-icon by custom ...
by jsetzer
2019-10-03 08:27
Forum: Bugs/annoyances
Topic: Data Format Bug
Replies: 5
Views: 918

Re: Data Format Bug

mekin wrote:
2019-10-03 07:43
The other thing, that the "." is the decimal as input, that's still a problem, that was my next issue to solve/search.
So, if you could put that in the Helper Library, it would be great!
I need to have a look how I did this last year.
by jsetzer
2019-10-03 08:21
Forum: Getting Started
Topic: hide add record parent table
Replies: 3
Views: 57

Re: hide add record parent table

You are welcome!
by jsetzer
2019-10-03 06:40
Forum: Bugs/annoyances
Topic: Data Format Bug
Replies: 5
Views: 918

Re: Data Format Bug

True, and you can change it by yourself as a workaround until it is fixed. tl;dr (short instructions) Close AppGini Insert the following line into C:\Program Files (x86)\AppGini\add-ons\dataFormats.cfg : Währung Euro (custom) example: 21.345,67 €); CONCAT(FORMAT(%%FIELD%%, 2, 'de_DE'), ' €...
by jsetzer
2019-10-03 06:16
Forum: Getting Started
Topic: hide add record parent table
Replies: 3
Views: 57

Re: hide add record parent table

Hi @mekin,

check the permissions of the group in admin-area.

If your user's group is allowed to insert records into the master-table, the button will be shown. In other words: revoke the "insert"-permission on that table for the group.

Hope this helps!
Best,
Jan
by jsetzer
2019-10-01 19:08
Forum: Getting Started
Topic: Public Web Application
Replies: 7
Views: 174

Re: Public Web Application

Thanks for opening this discussion! I can only contribute my personal opinion from my point of view and experience: Security of public web applications is a very sensitive and complex topic: It's not just about encrypting passwords, avoiding SQL injection, and handling sessions. It also covers relat...
by jsetzer
2019-10-01 11:34
Forum: Advanced Customizations > Hooks
Topic: Assign Record to Users automatically
Replies: 7
Views: 2034

Re: Assign Record to Users automatically

Hi,

try calling the built-in set_record_owner()-function instead and return FALSE afterwards. Otherwise AppGini will overwrite your ownership-definition by current user.

Code: Select all

set_record_owner("customers", $data["selectedID"], $UserName);
return FALSE;
Hope this helps!
Regards,
Jan
by jsetzer
2019-09-29 06:59
Forum: Getting Started
Topic: AppGini Helper JavaScript Library
Replies: 17
Views: 763

Re: AppGini Helper JavaScript Library

Hi Olaf, as I can see now, I got your question wrong: You do not need an additionaly save-button next to the lookup for saving the selected lookup value , but you need an additional save button to save the whole record - a clone of the existing save-button - at a different place. So please forget ab...
by jsetzer
2019-09-28 13:09
Forum: Getting Started
Topic: AppGini Helper JavaScript Library
Replies: 17
Views: 763

Re: AppGini Helper JavaScript Library

Re: (2) Additional button next to a lookup field Hi Olaf, usually the selected value of the lookup (dropdown) will be saved when saving the whole record. Is there a reason why you need to save that one field apart from the record? Can you please explain the use case and the aim a bit more?! What if ...
by jsetzer
2019-09-28 12:48
Forum: Getting Started
Topic: AppGini Helper JavaScript Library
Replies: 17
Views: 763

Re: AppGini Helper JavaScript Library

Re: (1) Download updates Hi Olaf, hi @all, that's right, during the ordering process you will receive an email from the fastspring-shop. That mail should contain a valid download link for your initial download. The same download link is valid for download of updates - if you have subscribed for upda...
by jsetzer
2019-09-28 12:43
Forum: Advanced Customizations > Hooks
Topic: live auto fill field based on other field content
Replies: 3
Views: 152

Re: live auto fill field based on other field content

You can use the .on("change", ...) -handler in TABLENAME-dv.js to detect the changes of both fields, "first_name" and "last_name". Create a function "updateName()". Whenever one of the inputs changes, call that javascript-function. That function should read both values by calling .val() on the input...
by jsetzer
2019-09-24 22:35
Forum: Getting Started
Topic: AppGini Helper JavaScript Library
Replies: 17
Views: 763

Re: AppGini Helper JavaScript Library

Thank you for your positive feedback! I really appreciate that! :) If you are interested, there are two more features coming soon and I have prepared a preview here: https://www.bizzworxx.de/en/appgini-helper/preview/ Grouping of fields in expandable/collapsible panels which save and restore their s...
by jsetzer
2019-09-21 17:49
Forum: Advanced Customizations > Others
Topic: site layout
Replies: 4
Views: 315

Re: site layout

Hi, as I have written in my previous post, the inline()-function will be available in next version. The currentversion does not have it, yet. These inline-functions will be available in next version of our AppGini Helper JavaScript library which can be purchased here. Stay tuned, next version will b...
by jsetzer
2019-09-18 20:34
Forum: Advanced Customizations > Others
Topic: site layout
Replies: 4
Views: 315

Re: site layout

Hi, as far as I know there is no software or plugin which allows drag & drop of fields in AppGini detail view forms directly. Nice idea :idea: but would be a lot of work to implement. But I can provide functionality to put fields inline by simple Javascript commands. Have a look here: chrome_2019-09...
by jsetzer
2019-09-17 12:11
Forum: Advanced Customizations > Hooks
Topic: How to display image in printing page
Replies: 24
Views: 343

Re: How to display image in printing page

Moh Youba wrote:
2019-09-17 11:57
Yes, works absolutely fine. Thank you a lot for time and kind support.
Great, I'm happy to hear that the problem is solved now!

Best,
Jan
by jsetzer
2019-09-17 11:33
Forum: Advanced Customizations > Hooks
Topic: How to display image in printing page
Replies: 24
Views: 343

Re: How to display image in printing page

Hi,

as far as I can see the path is missing.

Can you please try:

Code: Select all

<?php
$logo_src = getUploadDir("") .$order["logo"];
echo "<img src=\"{$logo_src}\" />";
?>
Regards,
Jan
by jsetzer
2019-09-16 07:04
Forum: Getting Started
Topic: php tricky format
Replies: 5
Views: 90

Re: php tricky format

OK, great!
by jsetzer
2019-09-16 06:56
Forum: Getting Started
Topic: php tricky format
Replies: 5
Views: 90

Re: php tricky format

Code: Select all

$day = '1';
$variable = $treinocardio11["cal{$day}"];

var_dump($variable);
exit;

$pdf->MultiCell(20,20,$variable ,0,'C',false);
can you post output please
by jsetzer
2019-09-16 06:52
Forum: Getting Started
Topic: php tricky format
Replies: 5
Views: 90

Re: php tricky format

Try this:

$day = '1';
$pdf->MultiCell(20,20,$treinocardio11["cal{$day}"],0,'C',false);
by jsetzer
2019-09-15 19:57
Forum: Getting Started
Topic: AppGini Helper JavaScript Library
Replies: 17
Views: 763

Re: AppGini Helper JavaScript Library

Hello AppGineers,

next version of our AppGini Helper JavaScript Library will provide a couple of new features for input fields:

2019-09-15_19-05-27.png
2019-09-15_19-05-27.png (4.51 KiB) Viewed 602 times
2019-09-15_19-18-01.png
2019-09-15_19-18-01.png (4.26 KiB) Viewed 602 times

Stay tuned, will be released the next days.

Regards,
Jan