Search found 1321 matches

by pböttcher
2021-10-21 16:02
Forum: Tips And Tricks
Topic: mySQL JSON JS Apexcharts
Replies: 1
Views: 99

Re: mySQL JSON JS Apexcharts

Hi you may try something like $keys=[]; $data=[]; $count=0; while($row = mysqli_fetch_assoc($query)) { $i=0; foreach ($row as $key => $val) { $keys[$i]=$key; $data[$key][]=$val; $i++; } $count++; } $data['name']=$keys; $i++; for ($j=0;$j<$i;$j++) { $json_array[]=(array('name' => $data['name'][$j], '...
by pböttcher
2021-10-21 15:14
Forum: Advanced Customizations > Hooks
Topic: Adding action buttons to detail view
Replies: 2
Views: 115

Re: Adding action buttons to detail view

Hi, not sure if I get you code correct, but I believe you are mixing the PHP and Javascript usage. In your case you need to react on the click of the button. If you have the information of the status on your page, you could just catch that information and check which button has been clicked. Then de...
by pböttcher
2021-10-21 15:06
Forum: Advanced Customizations > Others
Topic: Julian date
Replies: 5
Views: 177

Re: Julian date

Hi,

good to know what type you are looking for.

Try

Code: Select all

SELECT (YEAR(date)-2000)*1000 + DAYOFYEAR(date)
FROM `brine_lot`
WHERE `brine_lot`.`id`='%ID%'
by pböttcher
2021-10-18 18:27
Forum: Advanced Customizations > Others
Topic: Julian date
Replies: 5
Views: 177

Re: Julian date

Hi,

which is correct, or what would you expect?
by pböttcher
2021-10-17 08:19
Forum: Advanced Customizations > Others
Topic: Julian date
Replies: 5
Views: 177

Re: Julian date

Hi,

maybe you can try to get the julian date from your date field MYDATE (example) with

TO_DAYS(MYDATE)+1721060
by pböttcher
2021-10-16 08:01
Forum: Getting Started
Topic: Query for Multiple Tables
Replies: 1
Views: 70

Re: Query for Multiple Tables

Hi,
I guess that in your 3'rd part you need to iterate through the $timesheet array starting at the $timerecord_res sql statement and set the TABLE_N3.ts_no to the PK of TABLE_N2.
by pböttcher
2021-10-07 21:19
Forum: Getting Started
Topic: Print a lookup field as a check
Replies: 1
Views: 154

Re: Print a lookup field as a check

Hi,

you can try to add to your hooks/place-tv.js file:

Code: Select all

$j(function() {
   $j('.place-Active:contains(1)').find('a').text('').append('<i class="glyphicon glyphicon-check"></i>');
   $j('.place-Active:contains(0)').find('a').text('').append('<i class="glyphicon glyphicon-unchecked"></i>');
})
by pböttcher
2021-10-06 17:21
Forum: Getting Started
Topic: admin login error
Replies: 6
Views: 2664

Re: admin login error

Hi,

try to change the pwd to

$2y$10$nrt8C6FJNchiPSIeC2AlR.osAhbGUV3TbCDByn8vAhmSHiTT5qm/W

that would be the admin in the new version. Also remember to change the password also in the membership_users table
by pböttcher
2021-10-04 17:52
Forum: Advanced Customizations > Hooks
Topic: How Can I make the Box of Fields Wider in Detail View Page?
Replies: 4
Views: 360

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

Hi,
then it would be helpful to see how you page looks like. Which classes are you using for the box?
by pböttcher
2021-10-02 16:23
Forum: Getting Started
Topic: Filter by selected in table view
Replies: 7
Views: 428

Re: Filter by selected in table view

Hi,

ok, so you could call your page ( the one with the selected rows) with an additional parameter. In the hooks file -> Init function you can check for that parameter and set the $query->QueryWhere to your id's, or set filters to your id's (which every you like more).
by pböttcher
2021-10-02 10:24
Forum: Getting Started
Topic: Filter by selected in table view
Replies: 7
Views: 428

Re: Filter by selected in table view

Hi,

sorry, I'm still unclear on what you try to catch. So from what I understand, you want to filtern only the rows you selected by the checkbox. Correct?
by pböttcher
2021-10-01 19:29
Forum: Getting Started
Topic: Filter by selected in table view
Replies: 7
Views: 428

Re: Filter by selected in table view

Hi,
on what do you want to filter? Which field(s)?
by pböttcher
2021-09-24 19:44
Forum: AppGini Plugins
Topic: API Appgini
Replies: 3
Views: 249

Re: API Appgini

Sorry, I still do not understand what you need
by pböttcher
2021-09-23 20:29
Forum: AppGini Plugins
Topic: API Appgini
Replies: 3
Views: 249

Re: API Appgini

Hi,
can you please explain what you try to do and for what you need help. The information provided is very limited
by pböttcher
2021-09-15 13:56
Forum: Getting Started
Topic: Help! I don't see the data
Replies: 1
Views: 129

Re: Help! I don't see the data

Hi,

can you be a bit more specific.
- did you change any code
- did it work previously
- did you add additional code via hooks?
It sounds like there is a sql running false. But in order to understand, more background is required.
by pböttcher
2021-09-15 13:53
Forum: Getting Started
Topic: Enable Search on Subgrids?
Replies: 3
Views: 147

Re: Enable Search on Subgrids?

Hi,

no this is not an available feature and it will be quite complicated (at least from my point of view) to implement this.
by pböttcher
2021-08-27 17:39
Forum: Advanced Customizations > Hooks
Topic: Disable the save button depending on a field value
Replies: 9
Views: 590

Re: Disable the save button depending on a field value

Hi Kai,

yes it is correct. But without more information (or even better a sample) it is hard to help more.
by pböttcher
2021-08-24 16:40
Forum: Advanced Customizations > Hooks
Topic: Disable the save button depending on a field value
Replies: 9
Views: 590

Re: Disable the save button depending on a field value

Hi, for a checkbox you can try $j('#FIELDNAME').on('change',function(e) {if ($j(this).is(':checked')) {$j('#update').attr('disabled',false) } else {$j('#update').attr('disabled','disabled')}}) replace FIELDNAME with your fieldname for the checkbox. Also you should check at the beginning if the check...
by pböttcher
2021-08-24 08:25
Forum: Getting Started
Topic: How? Change tableview source to custom SQL query
Replies: 7
Views: 419

Re: How? Change tableview source to custom SQL query

Hi Olaf,

from my exerience it is not even necessary to go the route with the view. Leave the table as is from AppGini, use the init function to handle your query.
Make the table read-only as you will have fields that you add from other tables.
by pböttcher
2021-08-23 16:11
Forum: Advanced Customizations > Hooks
Topic: Disable the save button depending on a field value
Replies: 9
Views: 590

Re: Disable the save button depending on a field value

Hi,

can you be a bit more specific on what type of field/situation you want to disable the save button?
by pböttcher
2021-08-23 16:05
Forum: Getting Started
Topic: Specify image folder for specific page
Replies: 2
Views: 258

Re: Specify image folder for specific page

Hi,

I did not try this, but I think if you use the hooks/header-extras.php you could overwrite the default path $Translation['ImageFolder'] with one for your table. So check on which table you are currently working on and set $Translation['ImageFolder'] to the appropiate folder.
by pböttcher
2021-08-23 16:01
Forum: Getting Started
Topic: How? Change tableview source to custom SQL query
Replies: 7
Views: 419

Re: How? Change tableview source to custom SQL query

Hi Olaf,

what you could try is to create a "dummy" table in AppGini that holds the data you want to show. Here you can change the SQL query to your needs to show all the data that you want ($options).

Hope that gives you a starting point
by pböttcher
2021-08-23 15:56
Forum: Feature Suggestions
Topic: Radio Button Layout
Replies: 6
Views: 960

Re: Radio Button Layout

Hi, maybe a quick and dirty solution would be to use $j(function() { $j('[type="radio"').parent().find('br').remove(); $j('label[for*=radio]').css('min-width','50px'); }) If your lable is longer, just increase the min-width to match your layout wish. You can add this to your hooks/tablename-dv.js fi...