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['instructions'] != '') {
$where_data = $where_data . " AND instructions LIKE '%{$_POST['instructions']}%'";
}
$table_data = '|
';
$errand_res = $db->exec_query('management', ['*'], '', '', '', '', $where_data, "ORDER BY record_id DESC LIMIT {$_POST['row_count']}", false);
if ($errand_res->num_rows >= 1) {
while ($errand_info = $errand_res->fetch_assoc()) {
$errand_name_res = $db->exec_query("farming_action", ['*'], '', '', '', '', "record_id = {$errand_info['farming_action_id']}");
$errand_name_info = $errand_name_res->fetch_assoc();
$errand_type_res = $db->exec_query("farming_types", ['*'], '', '', '', '', "record_id = {$errand_info['farming_type_id']}");
$errand_type_info = $errand_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();
// $latest_comment_res = $db->exec_query("comment_logs", ["*"], "", '', '', '', "task_id = {$errand_info['record_id']}", "ORDER BY `record_id` DESC");
// $latest_comment = $latest_comment_res->fetch_assoc();
if (strlen($errand_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:
|
MANAGER:
|
COMMENTS:
|