Search found 1576 matches

by pböttcher
2023-03-16 20:02
Forum: Advanced Customizations > Hooks
Topic: Highlight date row of more than 1 day old.
Replies: 8
Views: 322

Re: Highlight date row of more than 1 day old.

Hi,

just to add, if you change the code, please consider how you change it.

In your code you have

Date = new Date(d[2] + '/' + d[1] + '/' + d[0]);

which causes the error. Use entereddate instead of Date and it should work.
by pböttcher
2023-03-15 20:20
Forum: Getting Started
Topic: Question about parent tables
Replies: 19
Views: 302

Re: Question about parent tables

Hi, you need to select the text from the produits table. Also the join needs to reflect the field that are connected `Produits`.`id` and `bondecommande`.`bon_produit` Try SELECT `Produits`.`prod` FROM `bondecommande` INNER JOIN `Produits` ON `Produits`.`id` = `bondecommande`.`bon_produit` WHERE `bon...
by pböttcher
2023-03-15 20:15
Forum: Advanced Customizations > Hooks
Topic: Highlight date row of more than 1 day old.
Replies: 8
Views: 322

Re: Highlight date row of more than 1 day old.

Hi, yo have 2 issues, first you did not put the code correctly. In your code you have $j(function() { $j('.louth-entereddate').each(function() { var entereddate = new date($j(this).text()); var yesterday = new date(new date().getTime() - (24 * 60 * 60 * 1000)); if (entereddate < yesterday) { $j(this...
by pböttcher
2023-03-14 21:28
Forum: Advanced Customizations > Hooks
Topic: Highlight date row of more than 1 day old.
Replies: 8
Views: 322

Re: Highlight date row of more than 1 day old.

Try

Code: Select all

var yesterday = new Date(new Date().getTime() - (24 * 60 * 60 * 1000));
instead of

Code: Select all

var yesterday = new Date(today.getTime() - (24 * 60 * 60 * 1000));
by pböttcher
2023-02-17 18:23
Forum: Advanced Customizations > Others
Topic: Field editor in table view
Replies: 34
Views: 17658

Re: Field editor in table view

Hi,

maybe you can share a bit more information.

As the call goes to the server (php file) you can check in der browser network tab if you see the call and the response.
Also you can trace the php side to see if your call statement to the mysql side workes.
by pböttcher
2023-02-12 13:43
Forum: Bugs/annoyances
Topic: Column sum wrong number format in table view
Replies: 3
Views: 187

Re: Column sum wrong number format in table view

Hi,

you can set

Code: Select all

<script>
AppGini.noLocaleFormatting=true;
</script>
in the hooks/footer-extras.php

this will prevent changing the sum field.
by pböttcher
2023-02-05 08:49
Forum: Getting Started
Topic: Trying to read src attribute of img tag
Replies: 1
Views: 304

Re: Trying to read src attribute of img tag

Hi,

Appgini will call the the display of the table, TV after a delete happend, so your script will not be executed.
by pböttcher
2023-02-04 08:27
Forum: Getting Started
Topic: Trying to relocate image to another folder
Replies: 2
Views: 203

Re: Trying to relocate image to another folder

Hi, without digging into it, I would assume that you navigate through the wrong directory structure. the after_insert function is located in the hooks directory, but called within the root directory. So the used path should be relativ to the root directory. If you put your test script in the hooks f...
by pböttcher
2023-01-30 19:01
Forum: Advanced Customizations > Hooks
Topic: $options->QueryFrom & INNER JOIN
Replies: 8
Views: 454

Re: $options->QueryFrom & INNER JOIN

Hi,

try

Code: Select all

$options->QueryFrom = ' `u05_tank` INNER JOIN `membership_users` ON `u05_tank`.`username` = `membership_users`.`memberID`';
I think there is no need for the first FROM. But looking at your original query you may need the other fields (joins) as well.
by pböttcher
2023-01-19 20:49
Forum: Advanced Customizations > Hooks
Topic: New Action Button
Replies: 1
Views: 185

Re: New Action Button

Hi, as far as I know, for new entries the button labels "Save New", if you edit an existing record the button text changes to "Save Changes". Not sure what else you would need. If you need to update a field on the "save change" action you can use the _before_update or _after_update function within t...
by pböttcher
2023-01-14 21:46
Forum: Getting Started
Topic: How to create thumbnail photos after the fact?
Replies: 8
Views: 400

Re: How to create thumbnail photos after the fact?

Hi, I think there are some points tu understand. Per default AppGini stores all images into one folder. If you want to store images in different folders this requires some code. For the default image folder (=baseUploadPath ) AppGini generates thumbnails for the TV and DV. These are named like the o...
by pböttcher
2023-01-14 12:19
Forum: Getting Started
Topic: How to create thumbnail photos after the fact?
Replies: 8
Views: 400

Re: How to create thumbnail photos after the fact?

Hi, maybe it is helpful to understand your setting. - you create a new backend (with AppGini). -> Do you have the information about the images stored in your database? Usually AppGini stores the name of the image in the database. - you changed the baseUploadPath -> are all your images in this path, ...
by pböttcher
2023-01-08 15:19
Forum: Advanced Customizations > Hooks
Topic: Hiding columns from non-owners
Replies: 17
Views: 1439

Re: Hiding columns from non-owners

Hi, I just reviewed the code above. Maybe the erro was with the fixed name "John". Try $from_old['postcode']="if ((select memberID from membership_userrecords where tableName='listing' and pkValue=listing.listingID)='".'$memberInfo['username']."', IF( CHAR_LENGTH(`postcode1`.`postcode`), CONCAT_WS('...
by pböttcher
2023-01-08 15:09
Forum: Bugs/annoyances
Topic: Save As Copy Not Working (child records)
Replies: 29
Views: 1448

Re: Save As Copy Not Working (child records)

As far as I could see the option is set "hard" to 0 so it should not matter. Any error messages in the Webserver/PHP log files?
by pböttcher
2023-01-08 15:08
Forum: Feature Suggestions
Topic: Multi select dropdown
Replies: 3
Views: 281

Re: Multi select dropdown

Well, where is your problem? You use your 'items' from your second table and populate the "firsttable.multiselectfield.csv" file on insert/update/delete from your second table. The tags table in the blog is your second table and the tag field is your items field. In your first table your create the ...
by pböttcher
2023-01-07 20:28
Forum: Feature Suggestions
Topic: Multi select dropdown
Replies: 3
Views: 281

Re: Multi select dropdown

Hi,

maybe this helps you as a starting point.

https://bigprof.com/blog/appgini/a-work ... gini-apps/
by pböttcher
2023-01-07 19:47
Forum: Bugs/annoyances
Topic: Save As Copy Not Working (child records)
Replies: 29
Views: 1448

Re: Save As Copy Not Working (child records)

Maybe you can check the server logs (webserver) to identify if there is an error
by pböttcher
2023-01-07 19:29
Forum: Bugs/annoyances
Topic: Save As Copy Not Working (child records)
Replies: 29
Views: 1448

Re: Save As Copy Not Working (child records)

is the CURLOPT_SSL_VERIFYPEER set to 1 or 0 ?
if 0 then it will probably not be the issue.
by pböttcher
2023-01-07 18:54
Forum: Bugs/annoyances
Topic: Save As Copy Not Working (child records)
Replies: 29
Views: 1448

Re: Save As Copy Not Working (child records)

That sounds like the causing issue. Can you revert on the server to an older version?
by pböttcher
2023-01-07 18:01
Forum: Bugs/annoyances
Topic: Save As Copy Not Working (child records)
Replies: 29
Views: 1448

Re: Save As Copy Not Working (child records)

Hi Ray,

can you dump you PHP version to verify that this is still the same than the one you have localy.
by pböttcher
2023-01-07 10:28
Forum: Advanced Customizations > Others
Topic: Send a SMS with text
Replies: 3
Views: 236

Re: Send a SMS with text

Hi, there is an error in the script: function envoyer_sms(GES_SMS, ids){ const message="Please enter data"; var text=window.prompt(message); var url = envoyer_sms.php?table=' + GES_SMS + "&id="+encodeURI(ids)+"&text="+encodeURI(text); window.open(url); } This is just a sample. It will send one messa...
by pböttcher
2023-01-07 08:50
Forum: Bugs/annoyances
Topic: Save As Copy Not Working (child records)
Replies: 29
Views: 1448

Re: Save As Copy Not Working (child records)

Hi Ray,

first question: Did you change anything? Re-loaded the app, or anything else?
by pböttcher
2023-01-06 22:10
Forum: Advanced Customizations > Others
Topic: Send a SMS with text
Replies: 3
Views: 236

Re: Send a SMS with text

Hi, if you have your function ready to send the sms on a selected record, you can just add a popup with requesting the data you need to be entered. Once the users entered that data, pass it to the "SEND SMS" PHP in the url. Now you can use the data to fill the SMS. something like: function send_sms ...
by pböttcher
2023-01-03 10:22
Forum: Advanced Customizations > Hooks
Topic: Scrollable table in DV-TV
Replies: 4
Views: 800

Re: Scrollable table in DV-TV

Hi,

this should work. Can you please recreate your app, clear the browser cache and change the 10 in the parent-children.php and check again.
by pböttcher
2022-12-24 15:42
Forum: Tips And Tricks
Topic: Not Empty field message
Replies: 4
Views: 477

Re: Not Empty field message

Hi Ron,

I would rather guess that there has been a hickup with the settings. I should just work fine with the option list and having it as required.

Maybe you can try that again.

Did you, by any chance, have the field definied different before you made it an option list?