| Server IP : 150.95.80.236 / Your IP : 3.139.72.254 Web Server : Apache System : Linux host-150-95-80-236 3.10.0-1160.105.1.el7.x86_64 #1 SMP Thu Dec 7 15:39:45 UTC 2023 x86_64 User : social-telecare ( 10000) PHP Version : 7.4.33 Disable Function : opcache_get_status MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/vhosts/pcu.in.th/sc.pcu.in.th/case_form/ |
Upload File : |
<!-- card :: start -->
<div class="card">
<!-- card body :: start -->
<div class="card-body">
<!--begin::Row-->
<div class="row mb-0">
<!--begin::Col-->
<div class="col-sm-10">
<!--begin::Title-->
<div class="mb-5 fs-3 fw-bolder text-dark text-center">แบบสอบถามภาระการดูแล Zarit Burden Interview (ZBI)
</div>
<!--end::Title-->
</div>
<!--end::Col-->
<!--begin::Col-->
<div class="col-sm-2 align-self-end">
<div class="d-flex justify-content-end bd-highlight">
<div class="p-2 bd-highlight">
<!--end::Action-->
<a href="index.php?p=form/form_zbi&case_id=<?php echo $_REQUEST['case_id']; ?>" class="btn btn-success ">ประเมินใหม่</a>
<!--end::Action-->
</div>
</div>
</div>
<!--end::Col-->
</div>
<!--end::Row-->
<!--begin::Accordion-->
<div class="accordion" id="kt_accordion_1">
<?php
$query_main = $conn->query("SELECT form_zbi.*
FROM form_zbi
WHERE form_zbi.case_id = '" . $_REQUEST['case_id'] . "' ORDER BY form_zbi.zbi_id DESC ");
$query_count = $conn->query("SELECT COUNT(zbi_id) AS count FROM form_zbi WHERE case_id = '" . $_REQUEST['case_id'] . "' ");
$fet_count = $query_count->fetch_object();
$i = $fet_count->count;
while ($fet_main = $query_main->fetch_assoc()) {
// $point = $fet_main->msca_point;
// $sql = "SELECT * FROM msca_result WHERE msca_pointstart <= '".$point."' AND msca_pointend >= '".$point."' ";
// $query = $conn->query($sql);
// $fet_result = $query->fetch_object();
?>
<!--begin::Accordion :: item-->
<div class="accordion-item">
<h2 class="accordion-header" id="self_ass<?php echo $i; ?>">
<button class="accordion-button fs-4 fw-bold <?php if ($i != $fet_count->count) {
echo "collapsed";
} ?>" type="button" data-bs-toggle="collapse" data-bs-target="#self_ass_body<?php echo $i; ?>" aria-expanded="false" aria-controls="self_ass_body<?php echo $i; ?>">
การประเมินครั้งที่ <?php echo $i; ?>
</button>
</h2>
<div class="d-flex justify-content-end bd-highlight">
<?php if ($fet_main['doctor_id'] == $_SESSION['user_id']) { ?>
<div class="p-2 bd-highlight">
<!--end::Action-->
<a href="index.php?p=edit_form/edit_zbi&case_id=<?php echo $_REQUEST['case_id'] ?>&zbi_id=<?php echo $fet_main['zbi_id']; ?>" class="btn btn-primary fs-7 ">แก้ไขข้อมูล</a>
<!--end::Action-->
</div>
<div class="p-2 bd-highlight">
<!--end::Action-->
<button onclick="return del(<?php echo $fet_main['zbi_id'] ?>,'zbi');" class="btn btn-danger fs-7">ลบ</button>
<!--end::Action-->
</div>
<?php } ?>
<div class="p-2 bd-highlight">
<!--end::Action-->
<a href="export_pdf/ex_pdf_zbi.php?zbi_id=<?php echo $fet_main['zbi_id'] . "&count=" . $i ?>&case_name=<?php echo $fet_case->case_tname . "" . $fet_case->case_name; ?>&form_date=<?php echo thaidate($fet_main['zbi_date']); ?>" class="btn btn-secondary fs-7" target="_blank">พิมพ์</a>
<!--end::Action-->
</div>
</div>
<div id="self_ass_body<?php echo $i; ?>" class="accordion-collapse collapse <?php if ($i == $fet_count->count) {
echo "show";
} ?>" aria-labelledby="self_ass<?php echo $i; ?>" data-bs-parent="#kt_accordion_1">
<!--begin::Accordion :: item :: body-->
<div class="accordion-body">
<!--begin::Accordion-->
<div class="accordion" id="kt_accordion_2">
<!--begin::Accordion :: item-->
<div class="accordion-item">
<h2 class="accordion-header" id="case_detail<?php echo $i; ?>">
<button class="accordion-button fs-4 fw-bold collapsed" type="button" data-bs-toggle="collapse" data-bs-target="#case_detail_body<?php echo $i; ?>" aria-expanded="false" aria-controls="case_detail_body<?php echo $i; ?>">
ข้อมูลทั่วไป
</button>
</h2>
<div id="case_detail_body<?php echo $i; ?>" class="accordion-collapse collapse" aria-labelledby="case_detail<?php echo $i; ?>" data-bs-parent="#kt_accordion_2">
<div class="accordion-body">
<!--begin::details View-->
<div class="card mb-5 mb-xl-10" id="kt_profile_details_view">
<!--begin::Card body-->
<div class="card-body p-9">
<!--begin::Row-->
<div class="row mb-7">
<!--begin::Label-->
<label class="col-md-2 fw-bolder fs-5 text-gray-800">ครั้งที่ประเมิน
: </label>
<!--end::Label-->
<!--begin::Col-->
<div class="col-sm-3">
<span class="fw-bold fs-5 text-dark text-start "><?php echo $i; ?>
</span>
</div>
<!--end::Col-->
<!--begin::Label-->
<label class="col-sm-2 fs-5 fw-bolder text-gray-800 ">วันที่ประเมิน
: </label>
<!--end::Label-->
<!--begin::Col-->
<div class="col-sm-3">
<span class="fw-bold fs-5 text-dark text-start"><?php echo thaidate($fet_main['zbi_date']); ?></span>
</div>
<!--end::Col-->
</div>
<!--end::Row-->
<!--begin::Row-->
<div class="row mb-7">
<!--begin::Label-->
<label class="col-sm-1 fs-5 fw-bolder text-gray-800 ">ชื่อ-นามสกุล : </label>
<!--end::Label-->
<!--begin::Col-->
<div class="col-sm-4">
<span class="fw-bold fs-5 text-dark text-start"><?php echo $fet_case->case_tname . "" . $fet_case->case_name; ?></span>
</div>
<!--end::Col-->
<!--begin::Label-->
<label class="col-sm-1 fs-5 fw-bolder text-gray-800 ">อายุ :
</label>
<!--end::Label-->
<!--begin::Col-->
<div class="col-sm-1">
<span class="fw-bold fs-5 text-dark text-start"><?php echo getAge($fet_case->case_bday) . " ปี" ?></span>
</div>
<!--end::Col-->
<!--begin::Label-->
<label class="col-sm-2 fs-5 fw-bolder text-gray-800 ">เลขบัตรประชาชน
: </label>
<!--end::Label-->
<!--begin::Col-->
<div class="col-sm-2">
<span class="fw-bold fs-5 text-dark text-start"><?php echo $fet_case->idcard; ?></span>
</div>
<!--end::Col-->
</div>
<!--end::Row-->
</div>
<!--end::Card body-->
</div>
<!--end::details View-->
</div>
</div>
</div>
<!--end::Accordion :: item-->
<!--begin::Accordion :: item-->
<div class="accordion-item">
<h2 class="accordion-header" id="case_result<?php echo $i; ?>">
<button class="accordion-button fs-4 fw-bold collapsed" type="button" data-bs-toggle="collapse" data-bs-target="#case_result_body<?php echo $i; ?>" aria-expanded="false" aria-controls="case_result_body<?php echo $i; ?>">
ผลการประเมิน
</button>
</h2>
<div id="case_result_body<?php echo $i; ?>" class="accordion-collapse collapse" aria-labelledby="case_result<?php echo $i; ?>" data-bs-parent="#kt_accordion_2">
<div class="accordion-body">
<div>
<!--begin::details View-->
<div class="card mb-5 mb-xl-10" id="kt_profile_details_view">
<!--begin::Card body-->
<div class="card-body p-9">
<?php
$query_form = $conn->query("SELECT * FROM main_form WHERE form_id = '58' ");
$a = 1;
while ($fet_form = $query_form->fetch_object()) {
?>
<!--begin::Title-->
<div class="mb-5 fs-4 fw-bolder text-dark text-center">
<?php echo $fet_form->form_name ?>
</div>
<!--end::Title-->
<!-- start : table -->
<div class="table-responsive">
<table id="kt_datatable_example_5" class="table table-responsive table-striped align-middle table-row-dashed fs-6 gy-5">
<thead>
<tr class="fw-bolder fs-5 text-gray-800 px-7">
<th class="min-w-100px align-middle text-center">
ลำดับ
</th>
<th class="min-w-350px align-middle text-center">
คำถาม
</th>
<th class="min-w-350px ">คำตอบ</th>
</tr>
</thead>
<tbody class="fw-bold fs-5 text-gray-800 px-7">
<?php
$b = 1;
$query_ark = $conn->query("SELECT main_ans.* , main_formans.ans_name, main_formark.ark_name
FROM main_ans
LEFT JOIN main_formans ON main_formans.ans_id = main_ans.ans_id
LEFT JOIN main_formark ON main_formark.ark_id = main_formans.ark_id
WHERE main_ans.form_ansid = '" . $fet_main['zbi_id'] . "' AND main_ans.form_id = '" . $fet_form->form_id . "'
AND main_ans.form_type = 'zbi'
");
while ($fet_ark = $query_ark->fetch_object()) {
?>
<tr>
<td class="fw-bold text-center">
<?php echo $b; ?>
</td>
<td class="fw-bold text-left">
<?php echo $fet_ark->ark_name; ?>
</td>
<td class="fw-bold text-left">
<?php echo $fet_ark->ans_name; ?>
</td>
</tr>
<?php
$b++;
}
?>
<tr>
<td class="fw-bolder">
คะแนนรวม
</td>
<td colspan="2" class="fw-bolder">
<?php echo $fet_main['zbi_point']; ?>
</td>
</tr>
<tr>
<td class="fw-bolder">
ผลการประเมิน
</td>
<td colspan="2" class="fw-bolder">
<?php echo $fet_main['zbi_pointname']; ?>
</td>
</tr>
</tbody>
</table>
</div>
<!-- end : table -->
<?php
$a++;
}
?>
</div>
<!--end::Card body-->
</div>
<!--end::details View-->
</div>
<!--end::Accordion::item :: body-->
</div>
</div>
</div>
<!--end::Accordion :: item-->
</div>
<!--end::Accordion-->
</div>
<!--end::Accordion :: item :: body-->
</div>
</div>
<!--end::Accordion :: item-->
<?php
$i--;
}
?>
</div>
<!--end::Accordion-->
</div>
<!-- card body :: end -->
</div>
<!-- card :: end -->
<script type="text/javascript">
function del(id, ac) {
// console.log(ssa_id)
Swal.fire({
title: 'คุณต้องการลบข้อมูลใช่หรือไม่?',
text: "ลบข้อมูลทั้งหมดของการประเมินครั้งนี้ การลบข้อมูลจะไม่สามารถกู้คืนได้ กรุณายืนยันการลบข้อมูลอีกครั้ง",
icon: 'warning',
showCancelButton: true,
confirmButtonColor: '#3085d6',
cancelButtonColor: '#d33',
confirmButtonText: 'ยืนยันลบข้อมูล',
cancelButtonText: 'ยกเลิก'
}).then((result) => {
if (result.isConfirmed) {
$.ajax({
url: "api/ac_delete_main.php",
type: "POST",
dataType: "html",
data: "ac=" + ac + "&id=" + id,
success: function(data, status) {
// console.log(data)
if (data == "OK") {
Swal.fire(
'สำเร็จ!',
'ลบข้อมูลเรียบร้อยแล้ว',
'success'
)
window.location.reload();
}
}
});
}
});
};
</script>