AppGini Community Forums

Hi,

thanks. So everything looks good. The issue could be that the script (on change) gets called bevor the dropdown is created. Can you try to change it to

$j('input[name="etu_sigle"]').on('change', function(){

Hi,

is the dropdown a lookup or a selection of values?
Can you post a screenshot with the debugger showing the dropdown definitions?

Hi,

hmmm, strange,

can you add an alert(sigid;) after the
var sigid = $j('input[name="etu_sigle"]').val();
and verify if that is the correct id?

If that is the correct id, can you run

select nbrhres from sigle where id= with the id you retrieved.

What is the result you get?

Hi,

sorry for my misunderstanding. If you need to ID, try instead

$j('input[name="etu_sigle"]').val()

Hi,

can you post a screenshot of the debugger showing the other_marriages name pls.

Hi,

try instead of

var sigid = $j('#etu_sigle').val();

var sigid = $j('#s2id_etu_sigle-container .select2-chosen').text();

Hi, you can add to you hooks/TABLENAME.php tablename_dv function. if(isset($_REQUEST['dvprint_x'])) return; ob_start(); ?> <script> $j(function(){ if ($j("#field2 option[value=texttocheckfor]:selected").length == 0){ $j("label[for='field3']").parent().hide(); } /* hide some stuff according to the al...

Additional to your question.

The

if(isset($_REQUEST['dvprint_x'])) return;

is just used if you try to print the page, as the logic does not necessarily apply. If it does for you, you can leave it out.

Thanks, can you try this: function Consumable_Tools_after_insert($data, $memberInfo, &$args){ $new_qty=sqlvalue("SELECT IFNULL(i.Stock_QTY,0)-{$data['Qty_Issued']} from Inventory i where i.InventoryID = {$data['Item']}"); sqlvalue("UPDATE Inventory i set i.Stock_QTY = {$new_qty} where i.InventoryID ...

Hi,

glad to see that it works half .

Sorry i forgot to mention that you need to change the marriage to name of your radio buttons. I guess it is Other_Marriages, but not sure.
You can check it through the development console and have a look at your radio buttons.

Just to add to my post, in the case statements you need of course to put your data instead of none, 1,2,3 reflecting your checkbox criteria.

Hi, you can try to put this in your Marriages.php Marriages_dv function : if(isset($_REQUEST['dvprint_x'])) return; ob_start(); ?> <script> $j(function(){ /* hide some stuff according to the already checked entry*/ if ($j("input#other_marriages2").is(":checked")) { $j("label[for='Marriage_2']").pare...

Hi, can you try $new_qty=sqlvalue("SELECT IFNULL(i.Stock_QTY-{$data['Qty_Issued']},0) from Inventory i where i.InventoryID = {$data['Stock_QTY']}"); sqlvalue("UPDATE Inventory i set i.Stock_QTY = {$new_qty} where i.InventoryID ={$data['Stock_QTY']}"); Are you having data in your inventory table?

Hi,

what is the link (lookup) from the Consumable_Tools to the Inventory? Is it the item?

Hi, put the code inside the function, like this. function Consumable_Tools_after_insert($data, $memberInfo, &$args){ $new_qty=sqlvalue("SELECT i.Stock_QTY-{$data['Qty_Issued']} from Inventory i where i.InventoryID = {$data['Stock_QTY']}"); sqlvalue("UPDATE Inventory i set i.Stock_QTY = {$new_qty} wh...

Hi, could it be that the values you try to retrieve from the table entrees ond/or sorties do not exist yet? If so, try the SQL with $total_entrees = sqlValue("SELECT IFNULL(total_tous_entree,0) FROM entrees WHERE matricule = '$id' "); $total_sorties = sqlValue("SELECT IFNULL(total_tous_sortie,0) FRO...

Hi,

can you post the complete function as you have it now. And a screenshot of the Consumable_Tools Stock_QTY defintion in AppGini

Hi, you can do this in the hooks/Consumable_Tools.php file. In the after_insert, after_update and bevor_delete function you need to add you calculation. so, eg. in the after_insert function you can try $new_qty=sqlvalue("SELECT i.Stock_QTY-{$data['Qty_Issued']} from Inventory i where i.id = {$data['...

Hi, assuming that duration as integer means days you want to add you could try $j(function(){ $j('#start_date-dd, #start_date-mm, #start_date').change(function(){ var start_date = $j('#start_date-mm').val()+"."+$j('#start_date-dd').val()+"."+$j('#start_date').val(); var duration = $j('#duration').va...

Hi,

sorry I still do not get what you try to do.
What is age, age_dt, dateOfStart? dateOfStar is a selectable date in your app?

Maybe you can explain more in detail what you try and also post a screenshot.

Hi,
is your question to increase the year count by the duration?
And where do you want to do the calculation, in the front-end (via JS), on the server side (via PHP) or on the DB side (via SQL)?

Hi,

you can use also just the detail view title to do this. Put you text in and get

Hi, thanks for providing the code. You could add the code that you have in the u02_person-dv.js in the hooks/u02_person.php u02_person_dv function. function u02_person_dv($selectedID, $memberInfo, &$html, &$args){ if(isset($_REQUEST['dvprint_x'])) return; ob_start(); ?> <script> $j(function(){ $j('#...

Hi, can you explain a little more what you want to acheive? If I understand what this picture shall explain, you would either need to the income expense budget data from your database, by setting the values, whenever you add/modify/delete an entry in the income / expense table. Otherwise you may run...

Hi,

can you share a part of your script used in the .js file for generating the alert.