To Get value by calculation column quantity - reguisition_confirm - reguisition_hold - return_qty - return_hold from mysql table grey_store_status on database dye_erp searching by user input form data of client_name, order_no, item_description, gsm field. Ajax response will store on a variable. validate user inputted data on quantity field to ensuring quantity field data is not higher then ajax returned variable data. If user input is higher value then variable data then show error message using sweet alert 2 and make input form quantity field blank with focus of quantity field . If user input lower value then variable data then do nothing. For achieving the said purpose write JavaScript (with jQuery), PHP for MySQL connectivity, and Ajax. Wrote below codes and tested outside phpmaker and found code is working. here in phpmaker i am confused where i need to php codes for connectivity.JavaScript codes placed in client side events :
{ // keys = event types, values = handler functions
"change": function(e) {
// Your code
// Get user input data
const formData = {
x_link_received_from: $("#x_link_received_from").val(),
x_grd_order_no: $("#x_grd_order_no").val(),
x_item_description: $("#x_item_description").val(),
x_gsm: $("#x_gsm").val(),
quantity: parseInt($("#x_quantity").val())
};
// Make an Ajax request to get the store status
$.ajax({
type: "POST",
url: "get_store_status.php",
data: formData,
dataType: "json",
success: function(response) {
// Check if the quantity input is higher than the store status
if (formData.x_quantity > response.storeStatus) {
// Show error message using SweetAlert2
Swal.fire({
icon: "error",
title: "Error",
text: "Input quantity is higher than available store status!",
}).then(function() {
// Clear and focus the quantity input field
$("#x_quantity").val("").focus();
});
} else {
// Do nothing, the quantity is valid
// You can add additional logic or actions here if needed
}
},
error: function() {
// Handle Ajax error here, if necessary
Swal.fire({
icon: "error",
title: "Error",
text: "Failed to fetch store status.",
});
}
});
// });
//});
}
}
for connecting with database i manually created and store get_store_status.php file in the same directory but getting error message “Failed to fetch store status” get_store_status.php contents the below codes
<?php
// Database connection parameters
// $servername = "localhost";
// $username = "root";
// $password = "";
// $dbname = "dye_erp";
// Get user input data from Ajax request
$link_received_from = $_POST['x_link_received_from'];
$grd_order_no = $_POST['x_grd_order_no'];
$item_description = $_POST['x_item_description'];
$gsm = $_POST['x_gsm'];
// Create a connection
// $conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
// if ($conn->connect_error) {
// die("Connection failed: " . $conn->connect_error);
// }
// Prepare the SQL query
$sql = "SELECT (quantity - reguisition_confirm - reguisition_hold - return_qty - return_hold) AS storeStatus
FROM grey_store_status
WHERE client_name = '$link_received_from' AND order_no = '$grd_order_no' AND item_description = '$item_description' AND gsm = '$gsm'";
// Execute the query and fetch the result
//$result = $conn->query($sql);
$result = ExecuteQuery($sql);
if ($result->num_rows > 0) {
$row = $result->fetch_assoc();
$storeStatus = $row['storeStatus'];
echo json_encode(array('storeStatus' => $storeStatus));
} else {
echo json_encode(array('storeStatus' => 0));
}
// Close the connection
// $conn->close();
?>
Can anyone tell me what i made mistake so that the above code is not working and getting error message “Failed to fetch store status” ?Thanks in advance.
If your script (get_store_status.php) is a standalone script, you cannot use the PHPMaker global function ExecuteQuery(). You may want to use Route_Action server event instead.Note that routing is used, you should not access a file by its file name. (NOT /my/path/…/xxx.php). You should use the route of your Custom File, e.g. “/basepath/route” (with the base path of your site).Also note that if you use Custom File with Include common files (so you can use global functions), and you put your output in the file content, the output is with other HTML, not just your JSON. That’s why you better use Route_Action event in your case. You better follow the example 4 in Ajax by API and Client Scripts.
I made necessary changes on coding level as tried to follow similar syntax of your given link. My project startup script and API action looks given below:startup script:
// Write your table-specific startup script here, no need to add script tags.
$("#x_quantity").change(function() {
// Get user input data
const link_received_from = document.getElementById('x_link_received_from').value;
const grd_order_no = document.getElementById('x_grd_order_no').value;
const item_description = document.getElementById('x_item_description').value;
const gsm = document.getElementById('x_gsm').value;
const quantity = parseFloat(document.getElementById('x_quantity').value);
// Make an Ajax request to get the store status
$.get(ew.getApiUrl(["getProductQuantity", link_received_from, grd_order_no, item_description, gsm, quantity]), function(response) {
// Check if the quantity input is higher than the store status
if ($(this).val() > response) {
// Show error message using SweetAlert2
Swal.fire({
icon: "error",
title: "Error",
text: "Input quantity is higher than available store status!",
}).then(function() {
// Clear and focus the quantity input field
$("#x_quantity").val("").focus();
});
} else {
// Do nothing, the quantity is valid
// You can add additional logic or actions here if needed
}
},
error: function() {
// Handle Ajax error here, if necessary
Swal.fire({
icon: "error",
title: "Error",
text: "Failed to fetch store status.",
});
}
});
// });
//});
API Action
// API Action event
function Api_Action($app)
{
$app->get('/getProductQuantity/({link_received_from}/{grd_order_no}/{item_description}/{gsm}/{quantity})', function ($request, $response, $args) {
// Get the input value
$grd_order_no = $args["grd_order_no"] ?? null;
$gsm = $args["gsm"] ?? null;
$item_description = $args["item_description"] ?? null;
$link_received_from = $args["link_received_from"] ?? null;
$quantity = $args["quantity"] ?? null;
if ($quantity !== null) {
$response = $response->write(ExecuteScalar("SELECT
( grey_store_status.quantity - grey_store_status.reguisition_confirm - grey_store_status.reguisition_hold - grey_store_status.return_qty - grey_store_status.return_hold )
FROM
grey_store_status
WHERE
grey_store_status.client_name = '" . AdjustSql($link_received_from) . "'
AND grey_store_status.order_no = '" . AdjustSql($order_no) . "'
AND grey_store_status.item_description = '" . AdjustSql($item_description) . "'
AND grey_store_status.gsm = '" . AdjustSql($gsm) . "'"));
var_dump($response);
}
return $response; // Return Psr\Http\Message\ResponseInterface object
});
}
After the above changes now getting the below error message .Uncaught SyntaxError: missing ) after argument list 88:32
at Yt (ew.js:6632:26)
at ew.js:6618:24
at Array.forEach ()
at Wt (ew.js:6618:6)
at Object.S (ew.js:7467:9)
at c (jquery.min.js?v=19.11.0:2:28599)
at Object.fireWith [as resolveWith] (jquery.min.js?v=19.11.0:2:29344)
at l (jquery.min.js?v=19.11.0:2:80328)
at XMLHttpRequest. (jquery.min.js?v=19.11.0:2:82782)I wanted to know, am i write codes by following right syntex? It will be very helpful for me if any expert check the above codes and identify problem .THANKS
You should remove “(” and “)”. If you want optional segments in route, read Optional Segments.And don’t var_dump($response); in your code. If you want to debug, you should use Log() and log the result of ExecuteScalar(), not the response object.
ThanksChecked and corrected the reason for occurring error. I am giving complete code because no another error message is coming which is not related to syntax. Besides, changed startup script to client side events in edit tag:
{ // keys = event types, values = handler functions
"change": function(e) {
// Your code
// Get user input data
const link_received_from = document.getElementById('x_link_received_from').value;
const grd_order_no = document.getElementById('x_grd_order_no').value;
const item_description = document.getElementById('x_item_description').value;
const gsm = document.getElementById('x_gsm').value;
const quantity = document.getElementById('x_quantity').value;
// Validate that quantity is a valid number
if (isNaN(x_quantity.value)) {
Swal.fire('Error', 'Please enter a valid quantity.', 'error');
document.getElementById("x_quantity").value='';
document.getElementById("x_quantity").focus();
return;
} else if (x_quantity.value <=0) {
Swal.fire('Error', 'Please enter a valid quantity.', 'error');
document.getElementById("x_quantity").value='';
document.getElementById("x_quantity").focus();
return;
}
// else {
// Do nothing, the quantity is valid
// You can add additional logic or actions here if needed
// }
// Make an Ajax request to get the store status
$.get(ew.getApiUrl(["getProductQuantity", link_received_from, grd_order_no, item_description, gsm, quantity]), function(response) {
// Check if the quantity input is higher than the store status
if (quantity > response) {
// Show error message using SweetAlert2
Swal.fire({
icon: "error",
title: "Error",
text: "Input quantity is higher than available store status!",
}).then(function() {
// Clear and focus the quantity input field
$("#x_quantity").val("").focus();
});
} else {
// Do nothing, the quantity is valid
// You can add additional logic or actions here if needed
}
});
}
}
API Code is:
// API Action event
function Api_Action($app)
{
$app->get('/getProductQuantity[/{link_received_from}[/{grd_order_no}[/{item_description}[/{gsm}[/{quantity}]]]]]', function ($request, $response, $args) {
// Get the input value
$grd_order_no = $args["grd_order_no"] ?? null;
$gsm = $args["gsm"] ?? null;
$item_description = $args["item_description"] ?? null;
$link_received_from = $args["link_received_from"] ?? null;
$quantity = $args["quantity"] ?? null;
//if ($quantity !== null) {
if ($quantity >= 0) {
$response = $response->write(ExecuteScalar("SELECT
( grey_store_status.quantity - grey_store_status.reguisition_confirm - grey_store_status.reguisition_hold - grey_store_status.return_qty - grey_store_status.return_hold )
FROM
grey_store_status
WHERE
grey_store_status.client_name = '" . AdjustSql($link_received_from) . "'
AND grey_store_status.order_no = '" . AdjustSql($order_no) . "'
AND grey_store_status.item_description = '" . AdjustSql($item_description) . "'
AND grey_store_status.gsm = '" . AdjustSql($gsm) . "'"));
}
return $response; // Return Psr\Http\Message\ResponseInterface object
});
}
Then problem solved and api is working. Thanks everyone for your valuable suggestions. Api is working when desire table is in single table add/edit but api not responding when desire table is as detail table mode. In grid mode not working.Do I need to replace input field name asof on grid mode? Any idea?
You should use jQuery .fields() Plugin to get the field values, not by document.getElementById(‘x_fieldname’).value or you need to change the row index yourself. You better read the examples of Client side events (for Add/Copy/Edit/Search) and see how they uses the plugin to get the field value without the need to consider which row.
{ // keys = event types, values = handler functions
"change keyup": function(e) {
var $row = $(this).fields(); // Get an object of all fields, each property is a jQuery object of the input element(s) of a field
var quantity = $row["quantity"];
var gsm = $row["gsm"];
var item_description = $row["item_description"];
var client_name = $row["client_name"];
}
}
According to jQuery .fields() Plugin example, my code should like this. Is this correct way?