add_styles_page();
$db = new db_safeguard();
// Fetch jobcard data
$record_id = (int) $_GET['record_id'];
$jobcard = $db->query("jobcards", "SELECT * FROM jobcards WHERE record_id = $record_id")->fetch_assoc();
// Users
$user_created = $db->query("users", "SELECT username FROM users WHERE record_id={$jobcard['user_id']}")->fetch_assoc()['username'];
$user_assigned = $db->query("users", "SELECT username FROM users WHERE record_id={$jobcard['user_assigned']}")->fetch_assoc()['username'];
// Timeline & Notes
$timeline = $db->query("jobcard_timeline", "SELECT * FROM jobcard_timeline WHERE jobcard_id={$record_id} ORDER BY record_id ASC");
$notes = $db->query("notes", "SELECT * FROM notes WHERE jobcard_id={$record_id}");
?>
Jobcard Timeline
num_rows > 0) {
$timeline->data_seek(0);
while ($t = $timeline->fetch_assoc()):
$label = str_replace("_", " ", $t['type']);
$time = date("Y-m-d H:i", strtotime($t['date_time']));
?>
-
No timeline events found";
} ?>
Meters Progress
data_seek(0);
$riem = 0;
$drill = 0;
$casing = 0;
$total = 0;
while ($t = $timeline->fetch_assoc()) {
if (strpos($t['type'], 'RIEM') !== false) {
$riem += $t['meters'];
$total += $t['meters'];
}
if (strpos($t['type'], 'DRILLING') !== false) {
$drill += $t['meters'];
$total += $t['meters'];
}
if (strpos($t['type'], 'CASING') !== false) {
$casing += $t['meters'];
$total += $t['meters'];
}
}
$riem_percent = ($total > 0) ? round($riem / $total * 100) : 0;
$drill_percent = ($total > 0) ? round($drill / $total * 100) : 0;
$casing_percent = ($total > 0) ? round($casing / $total * 100) : 0;
?>
Notes
num_rows > 0): ?>
| Reason |
Note |
Date |
Image |
fetch_assoc()): ?>
|
|
|
 '
style="width:80px; height:auto;"> |
No notes found";
endif; ?>
Payments
query("jobcard_payments", "SELECT * FROM jobcard_payments WHERE jobcard_id={$record_id} ORDER BY record_id ASC");
if ($payments_res->num_rows > 0): ?>
| Payment Method |
User |
Amount |
File |
Date |
fetch_assoc()):
$user_name = $db->query("users", "SELECT username FROM users WHERE record_id={$p['user_id']}")->fetch_assoc()['username'];
?>
|
|
R |
-
|
|
No payments found for this jobcard.