Search found 1615 matches

by pböttcher
2023-11-09 22:14
Forum: Advanced Customizations > Others
Topic: How do I save the amount and not the id in my database?
Replies: 3
Views: 935

Re: How do I save the amount and not the id in my database?

Hi pasbonte,

maybe you explain a bit more what you try to acheive and why you need to store that data in the same table. That could help in finding a solution.
by pböttcher
2023-10-22 16:13
Forum: Tips And Tricks
Topic: Grey one field according to another
Replies: 1
Views: 1668

Re: Grey one field according to another

Hi, as this is very specific the answer can not be clear. What kind of fields do you have? If you say gray out, does it mean that you want to make that field read-only? in general, with javascript (jquery) you can a "on change" event on you fields and react accordingly, e.g. $j(document).ready(funct...
by pböttcher
2023-10-15 15:56
Forum: Advanced Customizations > Others
Topic: Quick search: search for two items at the same time
Replies: 9
Views: 2045

Re: Quick search: search for two items at the same time

Can you show the _init function with the code and the _header -> tableview case as mentioned above.
by pböttcher
2023-10-15 15:26
Forum: Tips And Tricks
Topic: Date Picker
Replies: 2
Views: 954

Re: Date Picker

Hi Ron,

did you change anything? Upgrade you AppGini Version?
by pböttcher
2023-10-14 15:13
Forum: Advanced Customizations > Others
Topic: No Image Uploaded - default image req'd
Replies: 5
Views: 974

Re: No Image Uploaded - default image req'd

Hi Ron,

try in the function your_horse_after_insert and function your_horse_after_update

Code: Select all

if (empty($data['horse_pic'])) {
	$eo=[];
	$sql="UPDATE your_horse set horse_pic='no_image.png' where id={$data['selectedID']}";
	sql($sql,$eo);
}
by pböttcher
2023-10-14 11:26
Forum: Advanced Customizations > Others
Topic: automatic calculation instead of after update/insert code
Replies: 3
Views: 812

Re: automatic calculation instead of after update/insert code

Hi, without having the table really visibile it is hard to understand. You may try: SELECT SUM(`m2`.`Lordo`)-acquisto_peso.Tot_blocchi FROM `Movimenti_acquisto_peso` LEFT JOIN Movimenti_acquisto_peso m2 on m2.Totfat = Movimenti_acquisto_peso.Totfat LEFT JOIN acquisto_peso on acquisto_peso.id=m2.Totf...
by pböttcher
2023-10-13 20:55
Forum: Advanced Customizations > Others
Topic: No Image Uploaded - default image req'd
Replies: 5
Views: 974

Re: No Image Uploaded - default image req'd

Hi
you could add an image to the images folder and use sql to add this image in the after insert hook.
by pböttcher
2023-10-12 20:29
Forum: Advanced Customizations > Others
Topic: automatic calculation instead of after update/insert code
Replies: 3
Views: 812

Re: automatic calculation instead of after update/insert code

Hi, you may try: SELECT SUM(`Movimenti_acquisto_peso`.`Lordo`) - `Acquisto_peso`.Tot_blocchi` FROM `Movimenti_acquisto_peso`, `Movimenti_acquisto_peso` WHERE `Movimenti_acquisto_peso`.`Totfat`= `Movimenti_acquisto_peso`.`Totfat` AND `Acquisto_peso`.`id` = `Movimenti_acquisto_peso`.`Totfat` AND `Movi...
by pböttcher
2023-10-10 21:04
Forum: Getting Started
Topic: PHP number of days for each year between two dates
Replies: 2
Views: 802

Re: PHP number of days for each year between two dates

Hi, as you ask for a php solution you could try: // Define start and end dates $startdate='2021-05-12'; $enddate='2023-09-24'; $start_date = new DateTime($startdate); $end_date = new DateTime($enddate); // Define interest rates for each year $interest_rates = [ 2021 => 3.50, 2022 => 2.94, 2023 => 4....
by pböttcher
2023-10-07 13:01
Forum: Advanced Customizations > Others
Topic: Quick search: search for two items at the same time
Replies: 9
Views: 2045

Re: Quick search: search for two items at the same time

Hi, the actual answer is no, you cannot do it without adding some code. AppGini uses by default a wildcard search on the string you enter. So if you say that you use the "space" as a delimiter for your search, you might try this: in the hooks/TABLENAME.php -> _init function if (isset($_REQUEST['Sear...
by pböttcher
2023-10-01 19:18
Forum: Getting Started
Topic: Having a Problem getting a Global Variable
Replies: 2
Views: 1002

Re: Having a Problem getting a Global Variable

Hi, you reference 2 problems. But I'm not even clear on one of them. Can you specify this in more details? From what you write I would assume that you store in$memberInfo['custom'][0]; a custindex that you have in your product table as well. If you try to display only the product for the user which ...
by pböttcher
2023-10-01 19:07
Forum: Advanced Customizations > Hooks
Topic: Saves and all the fields are blocked
Replies: 3
Views: 785

Re: Saves and all the fields are blocked

Hi,

you could use the _footer hook (case 'detailview':) to check if the status = OFF and if the group of the user != Admins then disable all input fields.
There might be a bit more to do, but I hope this give you a starting point.
by pböttcher
2023-10-01 19:00
Forum: Getting Started
Topic: How can I do to display numbers in the format 1.234,56 ?
Replies: 8
Views: 3098

Re: How can I do to display numbers in the format 1.234,56 ?

Hi ,

which version of AppGini are you using? I think the newer versions allow using the Data format with calculated fields.
by pböttcher
2023-09-27 19:32
Forum: Tips And Tricks
Topic: Import csv
Replies: 12
Views: 1814

Re: Import csv

Hi Ron, is it possible that you do not have a value in the field Link_pCloud ? This field seems to be unique field and if you do not have a different value per row, only one row will be imported. I didn't see the field in the first dataset with the 3 records and no value in the second one with only ...
by pböttcher
2023-09-18 20:57
Forum: Getting Started
Topic: To do List, Work, but need to make recurrent in an easy way.
Replies: 1
Views: 757

Re: To do List, Work, but need to make recurrent in an easy way.

Hi,

what you can try.

In the hooks/__global.php -> login_ok function you can add a SQL statement to check if the records for today already exist. If not just create them as a copy from the last available TODO's with resetting the date value.
by pböttcher
2023-09-13 19:18
Forum: Getting Started
Topic: Update account auto
Replies: 2
Views: 875

Re: Update account auto

Hi,

just as an idea. Why not use the _after_insert hook and make the calculation with SQL for the ACCOUNTS table.
by pböttcher
2023-09-12 18:50
Forum: Advanced Customizations > Hooks
Topic: Validation help - In stock check
Replies: 6
Views: 1713

Re: Validation help - In stock check

Hi,
can you explain a bit detailled how your stucture looks like?
by pböttcher
2023-09-06 19:13
Forum: Getting Started
Topic: Fetch Issue
Replies: 3
Views: 998

Re: Fetch Issue

Hi,
csn check what type your trknum field has. Guess this has only 10 char.
by pböttcher
2023-09-03 07:07
Forum: Advanced Customizations > Hooks
Topic: Validation help - In stock check
Replies: 6
Views: 1713

Re: Validation help - In stock check

Hi,

at the time the user enters the Quantity (on change event) you could retrive the Quantity in stock via ajax and check if enough is available.
by pböttcher
2023-09-03 07:01
Forum: Getting Started
Topic: Suggestion about migration from IIS 7.5 to IIS 10.0
Replies: 5
Views: 1165

Re: Suggestion about migration from IIS 7.5 to IIS 10.0

Hi Alex,

for MySql the recent version should be fine.
by pböttcher
2023-08-31 10:22
Forum: Getting Started
Topic: Suggestion about migration from IIS 7.5 to IIS 10.0
Replies: 5
Views: 1165

Re: Suggestion about migration from IIS 7.5 to IIS 10.0

Hi,

I would suggest to go with a PHP Version 7.x for the older AppGini App.
by pböttcher
2023-06-08 18:32
Forum: Getting Started
Topic: action button after "Save Changes" was pressed
Replies: 3
Views: 1247

Re: action button after "Save Changes" was pressed

Hi,

just a short question to understand you need. Why cant you put your code in the _after_update hook?
by pböttcher
2023-06-08 17:45
Forum: Getting Started
Topic: Question about the Field Caption Length
Replies: 1
Views: 723

Re: Question about the Field Caption Length

Hi,

not sure if I get what you really try to acheive, but may try to add to your hooks/header-extras.php the following:

Code: Select all

<style>
.field-caption-tv {
	width: 200px !important;
}
</style>
where the 200px is just an example.