AppGini Community Forums

labib saleh wrote: ↑

2020-02-06 00:36

I used to have the following code working with version 5.51 but it stopped when switched to 5.81, can't figure why. Using northwind application I have two hooks files:
ajax-product-price.php

Code: Select all

<?php
	$currDir = dirname(__FILE__) . '/..';
	include("$currDir/defaultLang.php");
	include("$currDir/language.php");
	include("$currDir/lib.php");
	
	/* grant access to all users who have acess to the order_details table */
	$od_from = get_sql_from('order_details');
	if(!$od_from){
		header('HTTP/1.0 401 Unauthorized');
		exit;
	}
	
	$pid = intval($_REQUEST['pid']);
	
	$data['UnitPrice'] = sqlValue("select UnitPrice from products where ProductID='{$pid}'");
	$data['Quantity'] = sqlValue("select QuantityPerUnit from products where ProductID='{$pid}'");
	@header('Content-Type: application/json'); 
	echo json_encode($data);
?>

order_details-dv.js

Code: Select all

$j(function(){
	/* on changing product, retrieve unit price from products table and populate unit price field */
	$j('#ProductID-container').on('change', function(){
		var pid = $j('#ProductID').val();
		
		if(pid == '{empty_value}'){
			$j('#UnitPrice').val('');
		}else{
			$j.ajax({
				url: 'hooks/ajax-product-price.php',
				data: { pid: pid },
				success: function(data){
					$j('#UnitPrice').val(data.UnitPrice);
					$j('#Quantity').val(data.Quantity);
				}
			});
		}
	});
})

It's supposed to return two values for Orders Items table, that is you select the first item (Alice Mutton) the function should populate '39.00' for unit price and '20 - 1 kg tins' for quantity based on northwind's database, and that works perfectly when the application is posted using version 5.51. But it doesn't pull these fields right when the application is posted using version 5.81, instead it pulls the fields of the item that was selected before (if any)

Any ideas how to fix this please?

$pid = makesafe($_REQUEST['pid']);


	$con = mysqli_connect($dbServer, $dbUsername, $dbPassword);
	mysqli_select_db($con,$dbDatabase);

	$query = mysqli_query($con,"select * from tablename where ID= '{$pid}'");
	$tabledata = mysqli_fetch_array($query);

    echo json_encode($tabledata);

labib saleh wrote: ↑

2020-02-07 01:39

Thanks D Oliveira.
I've tried to implement the code instead of what I have in "ajax-product-price.php" but it returns this now ([object Object]), don't have much of experience in PHP programming so maybe I implemented the code wrong?

not getting why the same code works for 5.51 and not for 5.81

success: function(data){

if (data) {

var tbl = jQuery.parseJSON(data);

	$j('#UnitPrice').val(tbl.UnitPrice);
						
}

$j('#ProductID-container').on('change', function(){

$j('#ProductID-container').on('click', function(){

labib saleh wrote: ↑

2020-02-08 07:18

Thanks Jan.
I added console.log(data); after success and checked the console, there were no errors, but ajax returned wrong values for (Aniseed Syrup) as shown in the screenshot below:
capture.png


so I got:
UnitPrice: "39.00" and Quantity: "20 - 1 kg tins"
while (Aniseed Syrup) has UnitPrice: "10.00" and Quantity: "12 - 550 ml bottles", see screenshot
capture2.png



the weird thing that this same code in my first post works fine in version 5.51 but not when I upgraded to 5.81

D Oliveira wrote: ↑

2020-02-08 17:59

that might be a delay for the on change function [...]

jsetzer wrote: ↑

2020-02-08 18:38

D Oliveira wrote: ↑

2020-02-08 17:59

that might be a delay for the on change function [...]

I guess this will not be the reason.

You are right, that we cannot use jQuery's $j(selector).on("change", ...)-handler for AppGini lookup fields, because lookups are being created dynamically AFTER document ready. There are couple of forum posts here complaining about this and asking for help on reacting to lookup changes.

BUT the .onchange-handler, I have suggested, is part of our AppGini Helper JavaScript Library. This has been implemented differently and it should work on lookups as I have shown above and as labib saleh has confirmed. You can see the result in the console output of his response.

@labib saleh:
Unfortulately we cannot see the value of the selected lookup item. You should add some console.log(...) to ensure that lookup changes can be detected. As soon as we know, you can react to the lookup change AND can get the correct lookup-value.id, in the next step, you can do whatever you need using AJAX for example to fetch fresh data from a serverside PHP script. But first, please ensure the .onChange-handler works and you get the correct id. Then you can check your AJAX call and your serverside SQL for the right results.

Hope this helps!
Best,
Jan

// after success function

lookup_field_reload();

var second_ajax = AppGini.current_lookup_field.value;

// run a second ajax function

// on success

$j('#toreceivevalue').val(data);