54 lines
1.5 KiB
PHP
54 lines
1.5 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('includes/functions.php');
|
|
include('log_entry.php');
|
|
$act = isset($_POST['act']) ? $_POST['act'] : [];
|
|
error_log("RAW ACT DATA: " . print_r($act, true));
|
|
$data = [];
|
|
$ag_arr = [];
|
|
$activity_filter = "";
|
|
if (is_array($act) && count($act) > 0) {
|
|
$act_string = implode(",", $act);
|
|
error_log("ACTIVITY ARRAY TO STRING: " . $act_string);
|
|
$or = [];
|
|
foreach ($act as $a) {
|
|
$a = mysqli_real_escape_string($conn, $a);
|
|
$or[] = "FIND_IN_SET('$a', activity)";
|
|
}
|
|
$activity_filter = "(" . implode(" OR ", $or) . ")";
|
|
} else {
|
|
error_log("NO ACTIVITY RECEIVED!");
|
|
echo json_encode([]);
|
|
exit;
|
|
}
|
|
$query = "
|
|
SELECT agency
|
|
FROM tbl_items
|
|
WHERE $activity_filter
|
|
AND ohc_type_id = '" . $_SESSION['current_ohcttype'] . "'
|
|
";
|
|
error_log("FINAL AGENCY QUERY: " . $query);
|
|
|
|
|
|
$result = mysqli_query($conn, $query);
|
|
|
|
if (!$result) {
|
|
error_log("SQL ERROR: " . mysqli_error($conn));
|
|
echo json_encode([]);
|
|
exit;
|
|
}
|
|
if (mysqli_num_rows($result) > 0) {
|
|
while ($row = mysqli_fetch_assoc($result)) {
|
|
$agencyList = explode(",", $row['agency']);
|
|
foreach ($agencyList as $agencyID) {
|
|
if (!in_array($agencyID, $ag_arr)) {
|
|
$ag_arr[] = $agencyID;
|
|
$agencyName = getTableFieldValue('agency', 'agency_name', 'id', $agencyID);
|
|
$data[$agencyID] = $agencyName;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
error_log("FINAL AGENCY ARRAY: " . print_r($data, true));
|
|
echo json_encode($data);
|