| Server IP : 150.95.80.236 / Your IP : 18.220.191.227 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/uat.pcu.in.th/export_excel/ |
Upload File : |
<?php
header('X-Robots-Tag: noindex, nofollow');
session_start();
if (!isset($_SESSION['sess_id']) && !isset($_SESSION['user_id'])) {
// If the session is not set, redirect to the sign-in page
echo "<script>window.location.replace('../signin.php');</script>";
exit; // Ensure the script stops execution after redirecting
}
ob_start();
require '../connect.php';
require '../function.php';
?>
<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns="http://www.w3.org/TR/REC-html40">
<html>
<?php
$name = $_SESSION['user_fname'] . " " . $_SESSION['user_lname'];
//title
$table = "<table>
<thead>
<tr>
<th></th>
<th>รายงานแบบคัดกรองความรุนแรงในครอบครัว </th>
<th>ชื่อนักสังคมสงเคราะห์ $name</th>
</tr>
</thead>
</table>";
$result_point = array();
$result_pointname = array();
$result_count = array();
// $query = $conn->query("SELECT * FROM selfass_point");
// while ($fet = $query->fetch_object()) {
// array_push($result_point, $fet->selfpoint_value);
// array_push($result_pointname, $fet->selfpoint_show);
// }
//คำถาม
$result_ark = array();
$query_ark = $conn->query("SELECT * FROM msca_ark");
while ($fet_ark = $query_ark->fetch_object()) {
array_push($result_ark, $fet_ark->msca_arkname);
}
//header
$table .= "<table border='1'>
<thead>
<tr >
<th>ลำดับ</th>
<th>ชื่อผู้ป่วย</th>
<th>ผู้ประเมิน</th>
<th>วันที่ประเมิน</th>
";
$query_ark = $conn->query("SELECT * FROM main_formark WHERE form_id ='63' ");
while ($fet_ark = $query_ark->fetch_object()) {
$table .= "<th > $fet_ark->ark_name </th>";
}
// for ($i=0; $i < count($result_ark) ; $i++) {
// $table .= "<th >".$result_ark[$i]."</th>";
// }
$table .= "
</tr>
</thead>
<tbody>";
$count_i = 1;
$query_ansmain = $conn->query("SELECT form_panss.*, user_data.fname, user_data.lname, case_data.case_tname, case_data.case_name FROM form_panss
LEFT JOIN case_data ON case_data.user_id = form_panss.case_id
LEFT JOIN user_data ON user_data.user_id = form_panss.doctor_id
WHERE form_panss.doctor_id = '" . $_SESSION['user_id'] . "' ");
while ($fet_ansmain = $query_ansmain->fetch_assoc()) {
$table .= "
<tr>
<td> " . ($count_i) . " </td>
<td> " . $fet_ansmain['case_tname'] . " " . $fet_ansmain['case_name'] . " </td>
<td> " . $fet_ansmain['fname'] . " " . $fet_ansmain['lname'] . " </td>
<td> " . thaidate($fet_ansmain['panss_date']) . " </td>
";
$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_ansmain['panss_id'] . "' AND main_ans.form_id = '63' AND main_ans.form_type = 'panss'
");
while ($fet_ans = $query_ark->fetch_object()) {
$table .= "
<td> " . $fet_ans->ans_name . " </td>
";
}
$table .= "</tr>";
$count_i++;
}
//end
$table .= " </tbody>
</table>";
?>
<?php
header("Content-Type: application/vnd.ms-excel");
header('Content-Disposition: attachment; filename="case_panss.xls"');
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");
header("Content-Transfer-Encoding: binary");
// header("Content-Length: ".filesize("myexcel.xls"));
@readfile($filename);
echo $table;
?>