query("jobcard_timeline", "SELECT * FROM jobcard_timeline WHERE jobcard_id = {$_GET['record_id']} ORDER BY record_id ASC");
if ($res_data->num_rows > 0) {
$jobcard_res = $db->query("jobcards", "SELECT * FROM jobcards WHERE record_id = {$_GET['record_id']}");
$jobcard = $jobcard_res->fetch_assoc();
// echo $jobcard['record_id'];
?>
JOBCARD SUMMARY
| TYPE |
METERS |
DATE |
fetch_assoc()) {
if ($jc_timeline['type'] == "RIEM_STOP" || $jc_timeline['type'] == "RIEMING_STOP" || $jc_timeline['type'] == "RIEMING_PAUSED") {
$riem_meters += $jc_timeline['meters'];
}
if ($jc_timeline['type'] == "DRILLING_STOP" || $jc_timeline['type'] == "DRILLING_PAUSE") {
$drilling_meters += $jc_timeline['meters'];
}
if ($jc_timeline['type'] == "CASING_STOP" || $jc_timeline['type'] == "CASING_PAUSE") {
$casing_meters += $jc_timeline['meters'];
}
if ($jc_timeline['type'] == "BLASTING_START" || $jc_timeline['type'] == "BLASTING_STOP") {
$blasting_meters += $jc_timeline['meters'];
}
?>
| |
|
|
query("jobcards", "SELECT * FROM jobcards WHERE record_id = {$_GET['record_id']}");
$jobcard_data = $jobcard_data_res->fetch_assoc();
// echo "../jobcards/signatures/employee-jc" . $jobcard_data['jc_no'] . "-" . $_SESSION['user_id'] . "-signature.png";
if (file_exists("../jobcards/signatures/employee-jc" . $jobcard_data['jc_no'] . "-" . $_SESSION['user_id'] . "-signature.png")) {
?>
EMPLOYEE SIGNATURE
--signature.png'
alt='employee signature' class="signature_image"
style="width: 30vw; height:auto; border:2px solid black; border-radius:1vw;">
EMPLOYEE SIGNATURE
NO SIGNATURE FOUND
";
// echo "../jobcards/signatures/client-jc" . $jobcard_data['jc_no'] . "-" . $_SESSION['user_id'] . "-signature.png";
if (file_exists("../jobcards/signatures/client-jc" . $jobcard_data['jc_no'] . "-" . $_SESSION['user_id'] . "-signature.png")) {
?>
CLIENT SIGNATURE
CLIENT SIGNATURE
NO SIGNATURE FOUND
| NAME |
VALUE |
|
DATA NOT FOUND |
|
function_name("done");
$done_ajax->on_success("JOBCARD DONE");
$done_ajax->redirect('../home.php');
?>