= 1) {
$where_data[] = "jobcard_number = " . $jobcard_number . "";
}
$status = $_GET['status'];
if ($status >= 1 && $status != "STATUS") {
$where_data[] = "status = " . $status;
}
$client_id = $_GET['client_id'];
if ($client_id >= 1) {
$where_data[] = "client_id = " . $client_id . "";
}
$description = $_GET['description'];
if (strlen($description) >= 1) {
$where_data[] = "description LIKE '%" . $description . "%'";
}
$date_from = $_GET['date_from'];
if (strlen($date_from) >= 1) {
$where_data[] = "date_from >= '" . $date_from . "'";
}
$date_to = $_GET['date_to'];
if (strlen($date_to) >= 1) {
$where_data[] = "date_to >= '" . $date_to . "'";
}
if (count($where_data) > 0) {
$where = " WHERE " . implode(" AND ", $where_data);
} else {
$where = " WHERE 1";
}
echo $where;
$result = $db->conn->query("SELECT * FROM `jobcards` $where ORDER BY record_id DESC");
if ($result->num_rows > 0) {
while ($data = $result->fetch_assoc()) {
$client_name = $db->get_client_info($data['client_id']);
$status = $db->get_status($data['status']);
echo "
";
}
} else {
echo "
NO RESULTS
";
}