03-17-2023, 12:40 AM
(03-17-2023, 12:22 AM)gandalf Wrote: if i Remember properly, schedulesort was one of the file i had to fix to make it working. i could check when i'm back from work
If you could check that would be awesome, I do have something different going on with the Order By clause for this query but can't remember why, I think some columns weren't sorting properly and this fixed it but not sure what the * 1 means now.
PHP Code:
ORDER BY `{$sort}` ASC, `{$sort}` * 1 ASC
In my last post with the updated schedulesSort.php file I changed it to this just to test.
PHP Code:
ORDER BY schName ASC
If this is the problem or there's a different problem in this file can you explain why it works for me and others yet some it doesn't?
This is the whole file to compare with yours.
PHP Code:
<?php
header('Content-Type: application/json');
header("Access-Control-Allow-Origin: *");
$sort = $_GET["s"]; // get sort type
$asc = $_GET["a"]; // get sort type
require '../php/database.php';
if ($asc == 1) {
$query = sprintf("SELECT schedules.scheduleID, schedules.scheduleTypeID, schedules.pinID, schedules.offOn, schedules.schName, schedules.start, schedules.sun, schedules.mon, schedules.tue, schedules.wed, schedules.thu, schedules.fri, schedules.sat, schedules.repeatDays, schedules.enabled, schedules.schEmail, schedules.schAlert, scheduleType.type, pinsAvailable.name, pinsAvailable.iconID, dosingSchedules.mL
FROM schedules
LEFT JOIN scheduleType
ON scheduleType.scheduleTypeID = schedules.scheduleTypeID
LEFT JOIN pinsAvailable
ON pinsAvailable.pinID = schedules.pinID
LEFT JOIN dosingSchedules
ON dosingSchedules.scheduleID = schedules.scheduleID
ORDER BY `{$sort}` ASC, `{$sort}` * 1 ASC");
// ORDER BY LENGTH(`{$sort}`), `{$sort}` ASC");
// ORDER BY binray_not_needed_column ASC , `{$sort}` ASC");
}
else {
$query = sprintf("SELECT schedules.scheduleID, schedules.scheduleTypeID, schedules.pinID, schedules.offOn, schedules.schName, schedules.start, schedules.sun, schedules.mon, schedules.tue, schedules.wed, schedules.thu, schedules.fri, schedules.sat, schedules.repeatDays, schedules.enabled, schedules.schEmail, schedules.schAlert, scheduleType.type, pinsAvailable.name, pinsAvailable.iconID, dosingSchedules.mL
FROM schedules
LEFT JOIN scheduleType
ON scheduleType.scheduleTypeID = schedules.scheduleTypeID
LEFT JOIN pinsAvailable
ON pinsAvailable.pinID = schedules.pinID
LEFT JOIN dosingSchedules
ON dosingSchedules.scheduleID = schedules.scheduleID
ORDER BY `{$sort}` DESC, `{$sort}` * 1 DESC");
// ORDER BY LENGTH(`{$sort}`), `{$sort}` DESC");
// ORDER BY binray_not_needed_column DESC , `{$sort}` DESC");
}
//execute query
$result = $mysqli->query($query);
//loop through the returned data
$dataWindow = array();
foreach ($result as $row) {
$dataWindow[] = $row;
}
print json_encode($dataWindow);
//free memory associated with result
$result->close();
//close connection
$mysqli->close();