AppGini Community Forums

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...

Hi,
just to be sure. This is the query that you have in the APPGini Advanced -> "User this SQL query .... " field.

Hi,

can you post your custom sql that you use for the lookup.

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_...

What is not working? Are you getting wrong results, no results, ???
Can you share your table definitions with the relations?

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...

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...

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...

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.

Hi,

maybe this gets you further

viewtopic.php?f=7&t=3004&p=9972#p9954

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...

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

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...

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 ...

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).

Hi,

can you post the code you are using. Are you using a combined tableview+detailview?

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...

Hi,

the question is, how would you let the user decide which page to start with.

see

viewtopic.php?f=2&t=3049

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...

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");
}

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?

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...

Hi,

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

the code:
this would only allow the members of the Admins group to use the CSV download

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