';
$errand_res = $db->exec_query('management', ['*'], '', '', '', '', "completed = ' ' AND user_id_assigned = {$_SESSION['user_id']}", "ORDER BY rating DESC");
if ($errand_res->num_rows >= 1) {
while ($errand_info = $errand_res->fetch_assoc()) {
$task_type_res = $db->exec_query("farming_types", ['*'], '', '', '', '', "record_id = {$errand_info['farming_type_id']}");
$task_type_info = $task_type_res->fetch_assoc();
$user_id_res = $db->exec_query("users", ['*'], '', '', '', '', "record_id = {$errand_info['user_id_assigned']}");
$user_id_info = $user_id_res->fetch_assoc();
$style = '';
if ($errand_info['rating'] >= 1 && $errand_info['rating'] <= 3) {
$style = 'style="background-color:green"';
} elseif ($errand_info['rating'] >= 4 && $errand_info['rating'] <= 6) {
$style = 'style="background-color:orange"';
} elseif ($errand_info['rating'] >= 7 && $errand_info['rating'] <= 10) {
$style = 'style="background-color:red"';
}
$table_data = $table_data . "
|
|
|
|
| |
";
}
} else {
$table_data = "
| NO RESULTS |
";
}
?>
|
FARMING TYPE:
|
RATING:
|
CREATED:
|
DONE BY:
|
BLOCKS:
|
ACTION:
|