block('add_task.php', "ADD");
}
$html->block('incomplete_task.php', "OPEN");
?>
';
$task_res = $db->exec_query('tasks', ['*'], '', '', '', '', "$where_data AND date_completed = '' ", "ORDER BY record_id DESC LIMIT 100");
if ($task_res->num_rows >= 1) {
while ($task_info = $task_res->fetch_assoc()) {
$task_name_res = $db->exec_query("farming_action", ['*'], '', '', '', '', "record_id =
{$task_info['farming_action_id']}");
$task_name_info = $task_name_res->fetch_assoc();
$task_type_res = $db->exec_query("farming_types", ['*'], '', '', '', '', "record_id = {$task_info['farming_type_id']}");
$task_type_info = $task_type_res->fetch_assoc();
$user_id_res = $db->exec_query("users", ['*'], '', '', '', '', "record_id = {$task_info['user_id']}");
$user_id_info = $user_id_res->fetch_assoc();
$latest_comment_res = $db->exec_query(
"comment_logs",
["*"],
"",
'',
'',
'',
"task_id = {$task_info['record_id']}",
"ORDER BY `record_id` DESC"
);
$latest_comment = $latest_comment_res->fetch_assoc();
if (strtotime($task_info['action_date']) > strtotime(date('Y-m-d H:i', strtotime("+2 Hours")))) {
$Compelted = "YES";
$style = "style='background-color:green;'";
} else {
$Compelted = "NO";
$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:
|
ACTION DATE:
|
SECTION MANAGER:
|
ACTION:
|