Search found 449 matches

by pböttcher
2019-06-19 20:26
Forum: Getting Started
Topic: How? Sort lookup by different column
Replies: 5
Views: 25

Re: How? Sort lookup by different column

Hi, can you try this: SELECT * FROM (SELECT ecomo_Location.ID_LocationNum, ecomo_Location.Location_Auto, ecomo_Lagerorte.Lagerort_Kurz, ecomo_Location.ID_posX, ecomo_Location.ID_posY, ecomo_Location.ID_posZ FROM (SELECT ecomo_Location.ID_Lagerorte, ecomo_Location.ID_posX, ecomo_Location.ID_posY, Min...
by pböttcher
2019-06-19 17:16
Forum: Getting Started
Topic: How? Sort lookup by different column
Replies: 5
Views: 25

Re: How? Sort lookup by different column

Hi,
just to be sure. This is the query that you have in the APPGini Advanced -> "User this SQL query .... " field.
by pböttcher
2019-06-19 15:39
Forum: Getting Started
Topic: How? Sort lookup by different column
Replies: 5
Views: 25

Re: How? Sort lookup by different column

Hi,

can you post your custom sql that you use for the lookup.
by pböttcher
2019-06-19 07:35
Forum: Advanced Customizations > Others
Topic: More than 1 calculation
Replies: 11
Views: 69

Re: More than 1 calculation

Hi, I think the issue is because you try to get the matl_price from the quoting table, but instead the matl_price in the quoting table is a lookup to the materials table. So you need actually to pick the matl_price from the materials table. so you may try this $from = get_sql_from('quoting'); $matl_...
by pböttcher
2019-06-18 15:18
Forum: Advanced Customizations > Others
Topic: More than 1 calculation
Replies: 11
Views: 69

Re: More than 1 calculation

What is not working? Are you getting wrong results, no results, ???
Can you share your table definitions with the relations?
by pböttcher
2019-06-18 07:57
Forum: Tips And Tricks
Topic: scrollable table in table view
Replies: 9
Views: 1399

Re: scrollable table in table view

Hi, here a new version. Hope that fits most needs. Put this either in the hooks/footer-extras.php or if you want to apply it to only one table in the hooks/TABLENAME.php file to the tableview function. <?php if ($_REQUEST['Print_x'] != 1) { echo $_REQUEST['Print_x']; echo <<<EOT <style> .table-respo...
by pböttcher
2019-06-18 06:25
Forum: Advanced Customizations > Others
Topic: More than 1 calculation
Replies: 11
Views: 69

Re: More than 1 calculation

Hi, you can do as many calculation as complex as you wish. If you need some values from the DB, retrieve them via sql or sqlvalue. The $data array hold all your field that will be updated in the DB for this table. But you could even update via SQL any other data in your database. It's your choice. I...
by pböttcher
2019-06-17 16:02
Forum: Advanced Customizations > Hooks
Topic: Calculate between 2 Tables
Replies: 4
Views: 35

Re: Calculate between 2 Tables

Hi, well it depends what you try to acheive :-). I guess you wan to display the calculated lbs_per_m when the user changes the quoting_ID. In that case you need to adjust you sql statement in the ajax-quoting-part_weight.php to give you the calculated value. Now you just retrieve the value. Also you...
by pböttcher
2019-06-17 15:13
Forum: Advanced Customizations > Hooks
Topic: Calculate between 2 Tables
Replies: 4
Views: 35

Re: Calculate between 2 Tables

Hi,

can you replace in your results.php file the $data['part_weight'] with $data['quoting_ID']

Also I do not understand what you try to do in the results-dv-js. To me there seems to be no part_weight in that table.
by pböttcher
2019-06-14 05:22
Forum: Advanced Customizations > Hooks
Topic: Automatism to duplicate records from a table to another
Replies: 2
Views: 78

Re: Automatism to duplicate records from a table to another

Hi, sure this is possible, you need to add you code to the hooks/appointments.php file into the function after_insert and after_update. Maybe as well into after_delete, but you did not mention what should happen if a record is deleted. If deleted records should remain in the public appointments tabl...
by pböttcher
2019-06-13 08:35
Forum: Bugs/annoyances
Topic: Bug 5.75: hook _global login_ok can not use absolute URL
Replies: 2
Views: 37

Re: Bug 5.75: hook _global login_ok can not use absolute URL

Hi,

the $args feature seems not to be implemented in the login_ok check.

If you need this feature you can call

redirect('https://www.google.com',true);

directly instead of passing the url in the return
by pböttcher
2019-06-13 06:38
Forum: Advanced Customizations > Others
Topic: User allowed to set desired start page
Replies: 13
Views: 195

Re: User allowed to set desired start page

Hi, so fi you have your table (lets assume it is called "USERHOME" and within this table you have a field called "HOMEPAGE" and you user the memeberID as matching key. You could do: function login_ok($memberInfo, &$args){ $userpage = sqlvalue("SELECT HOMEPAGE from USERHOME where memberID = '".$membe...
by pböttcher
2019-06-12 20:04
Forum: Advanced Customizations > Hooks
Topic: Update field not showing in detail view
Replies: 4
Views: 116

Re: Update field not showing in detail view

Hi, this is the way AppGini works. If you set a field to read-only or hidden in the detail view, AppGini will ignore that field for the sql calls to the database. So you will not be able to manipulate the field via the $data array. You could update the database directly, as you have all information ...
by pböttcher
2019-06-12 19:30
Forum: Bugs/annoyances
Topic: Annoyance 5.75: Can not hide Group
Replies: 3
Views: 43

Re: Annoyance 5.75: Can not hide Group

Hi,

I don't this that this is a bug, nor an annoyance. If you hide all entries that belong to the group via the "hide link from homepage", the group they belong to will not be display either (so it will be hidden).
by pböttcher
2019-06-11 15:35
Forum: Advanced Customizations > Hooks
Topic: Update field not showing in detail view
Replies: 4
Views: 116

Re: Update field not showing in detail view

Hi,

can you post the code you are using. Are you using a combined tableview+detailview?
by pböttcher
2019-06-11 15:33
Forum: Feature Suggestions
Topic: Define application language / let users choose language
Replies: 5
Views: 116

Re: Define application language / let users choose language

Hi, you can try this: create a directory languages in the root of your app. Copy the languages you want to provide to the user into that directory. eg. german.php spanish.php italian.php ... now in the hooks folder you create a file language.php and insert <?php $mi = getMemberInfo(); $lang=$mi['cus...
by pböttcher
2019-06-10 09:33
Forum: Advanced Customizations > Others
Topic: User allowed to set desired start page
Replies: 13
Views: 195

Re: User allowed to set desired start page

Hi,

the question is, how would you let the user decide which page to start with.
by pböttcher
2019-06-09 09:54
Forum: Getting Started
Topic: How? Filter (or search?) table by click on cell
Replies: 7
Views: 176

Re: How? Filter (or search?) table by click on cell

Hi, you can try this: put in your hooks/TABLENAME-tv.js file: $j(function () { var filter='TABLENAME_view.php?SortField=&SortDirection=&FilterAnd[1]=and&FilterField[1]=FIELDCOUNT&FilterOperator[1]=equal-to&FilterValue[1]='; $j('[id*=TABLENAME-FIELDNAME] a').each(function() { $j(this).attr('href', fi...
by pböttcher
2019-06-09 08:20
Forum: Advanced Customizations > Others
Topic: User allowed to set desired start page
Replies: 13
Views: 195

Re: User allowed to set desired start page

Hi,

yes you can use something like this pseudocode.

function login_ok($memberInfo, &$args){

catch USERPAGE for $memberInfo['username'] // maybe via an sql query from a config table.
redirect("USERPAGE");
}
by pböttcher
2019-06-08 14:34
Forum: Getting Started
Topic: How? Filter (or search?) table by click on cell
Replies: 7
Views: 176

Re: How? Filter (or search?) table by click on cell

Hi,

just a question to this. How would you like to get to the detail records if you make the all the "links" to the details as filters?
by pböttcher
2019-06-08 08:57
Forum: Advanced Customizations > Hooks
Topic: Save CSV for specific groups only
Replies: 4
Views: 94

Re: Save CSV for specific groups only

Hi, you can do e.g. if (!in_array($memberInfo['group'],array('Admins','Group2','Group3','etc...') or if ($memberInfo['group'] != 'Admins' && $memberInfo['group'] != 'Group2' && $memberInfo['group'] != 'Group3' etc... ) replace Group2, Group3 with your groups, the etc... is symbolic for additional gr...
by pböttcher
2019-06-07 20:24
Forum: Advanced Customizations > Hooks
Topic: Save CSV for specific groups only
Replies: 4
Views: 94

Re: Save CSV for specific groups only

Hi,

you can use the hooks/TABLENAME.php file (TABLENAME = your table) and put into the
TABLENAME_init function

the code:

Code: Select all

if ($memberInfo['group'] != 'Admins') 
{
$options->AllowCSV = 0; 
}
this would only allow the members of the Admins group to use the CSV download
by pböttcher
2019-06-05 07:53
Forum: Getting Started
Topic: How? Make one field read-only for usergroup
Replies: 11
Views: 114

Re: How? Make one field read-only for usergroup

ok, so is it working now? in the code you posted you had #Container