block('add_errand.php', "ADD");
}
$html->block('manage_errands.php', "OPEN");
?>
';
$manage_res = $db->exec_query('management', ['*'], '', '', '', '', "$where_data AND date_completed = '' ", "ORDER BY record_id DESC LIMIT 100");
if ($manage_res->num_rows >= 1) {
while ($manage_info = $manage_res->fetch_assoc()) {
$farmimg_name_res = $db->exec_query("farming_action", ['*'], '', '', '', '', "record_id ={$manage_info['farming_action_id']}");
$farming_name_info = $farmimg_name_res->fetch_assoc();
$farming_type_res = $db->exec_query("farming_types", ['*'], '', '', '', '', "record_id = {$manage_info['farming_type_id']}", '',false);
$farming_type_info = $farming_type_res->fetch_assoc();
$user_id_res = $db->exec_query("users", ['*'], '', '', '', '', "record_id = {$manage_info['user_id_assigned']}",'',false);
$user_id_info = $user_id_res->fetch_assoc();
if (strtotime($manage_info['date_completed']) > strtotime(date('Y-m-d H:i', strtotime("+2 Hours")))) {
$Compelted = "YES";
$style = "style='background-color:green;'";
} else {
$Compelted = "";
$style = "style='background-color:red;'";
}
$table_data = $table_data . "
|
|
|
| ";
if ($_SESSION['user_type'] == "MANAGER") {
$table_data = $table_data . "
|
";
}
$table_data = $table_data . "";
}
} else {
$table_data = "
| NO RESULTS |
";
}
?>
|
FARMING TYPE:
|
FARMING ACTION:
|
START DATE:
|
MANAGER:
|
ACTION:
|