query(
"jobcards",
"SELECT *
FROM jobcards
WHERE status = 0 AND team_assigned_id = $team_id
ORDER BY jc_no DESC"
);
// echo "SELECT *
// FROM jobcards
// WHERE status = 0 AND team_assigned_id = $team_id
// ORDER BY jc_no DESC";
if ($res->num_rows > 0) {
$data_res = $res->fetch_assoc();
// echo "SELECT * FROM jobcard_timeline WHERE jobcard_id = $data_res[record_id]";
$timeline_res = $db->query("jobcard_timeline", "SELECT * FROM jobcard_timeline WHERE jobcard_id = {$data_res['record_id']} ORDER BY record_id DESC LIMIT 1");
$timeline = $timeline_res->fetch_assoc();
if ($timeline['status'] == 1) {
echo "No active jobcards";
exit;
} else {
?>
Jobcard #
No active jobcards";
exit;
}
// if ($res->num_rows === 0) {
// echo "No active jobcards";
// exit;
// }
// while ($jc = $res->fetch_assoc()) {
// ?>