6) {
$where_data = $where_data . " AND date_created BETWEEN '{$_POST['date_from']}' AND '{$_POST['date_to']}' ";
}
if ($_POST['farming_type_id'] != '0') {
$where_data = $where_data . " AND farming_type_id = {$_POST['farming_type_id']}";
}
if ($_POST['farming_action_id'] != '0') {
$where_data = $where_data . " AND farming_action_id = {$_POST['farming_action_id']}";
}
if ($_POST['farm_id'] != '0') {
$where_data = $where_data . " AND farm_id = {$_POST['farm_id']}";
}
if ($_POST['user_id'] != 'ALL') {
$where_data = $where_data . " AND user_id = {$_POST['user_id']}";
}
if ($_POST['comment'] != '') {
$where_data = $where_data . " AND comments LIKE '%{$_POST['comment']}%'";
}
if ($_POST['cluster'] != '') {
$cluster_arr = explode(",", $_POST['cluster']);
foreach ($cluster_arr as $cluster) {
$cluster_data[] = "cluster_ids LIKE '%$cluster%'";
}
$where_data = $where_data . "AND (" . implode(" OR ", $cluster_data) . ")";
}
if ($_POST['instruction'] != '') {
$where_data = $where_data . " AND instruction LIKE '%{$_POST['instruction']}%'";
}
$table_data = '|
';
$task_res = $db->exec_query('tasks', ['*'], '', '', '', '', $where_data, "ORDER BY record_id DESC LIMIT {$_POST['row_count']}", false);
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 (strlen($task_info['date_completed']) > 5) {
$Compelted = "YES";
$style = "style='background-color:green;'";
} else {
$Compelted = "NO";
$style = "style='background-color:red;'";
}
$table_data = $table_data . "
|
|
|
|
|
|
";
}
} else {
$table_data = "| NO RESULTS |
";
}
?>
|
FARMING TYPE:
|
FARMING ACTION:
|
COMPLETED:
|
SECTION MANAGER:
|
COMMENTS:
|