| Server IP : 103.233.192.212 / Your IP : 18.219.250.4 Web Server : Apache/2 System : Linux sv1.inde.co.th 3.10.0-1160.36.2.el7.x86_64 #1 SMP Wed Jul 21 11:57:15 UTC 2021 x86_64 User : sumpatuan ( 1058) PHP Version : 5.5.38 Disable Function : symlink,shell_exec,exec,proc_close,proc_open,popen,system,dl,putenv,passthru,escapeshellarg,escapeshellcmd,pcntl_exec,proc_get_status,proc_nice,proc_terminate,pclose,ini_alter,virtual,openlog,ini_restore MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/sumpatuan/domains/sumpatuan.go.th/public_html/main/ |
Upload File : |
<?php
session_start();
require_once('db_main.php');
date_default_timezone_set("Asia/Bangkok");
header('Content-Type: text/html; charset=UTF-8');
if( isset($_SESSION['login_nb_session']) ){
$user_newbook = $_SESSION['login_nb_session'];
$sql_user = " SELECT * FROM `data_newsbookmb` WHERE `user_newsbookmb`='$user_newbook' ";
$qr_user = mysqli_query($con_db_main,$sql_user) or die( mysqli_error($con_db_main));
$rs_user = mysqli_fetch_assoc($qr_user);
if( $rs_user['name_newsbookmb']=="" ){
echo "<SCRIPT type='text/javascript'>
alert('กรุณาเข้าสู่ระบบ [2]');
window.location.replace('topNewsbook');
</SCRIPT>";
exit;
}else{
$namemb_newsbook = $rs_user['name_newsbookmb'];
$sql_data = " SELECT *, CONCAT( DAY(str_to_date(`date_newsbook`,'%d/%m/%Y')) ,'/', MONTH(str_to_date(`date_newsbook`,'%d/%m/%Y')) ,'/', YEAR(str_to_date(`date_newsbook`,'%d/%m/%Y'))+543 ) AS 'cv_date_newsbook'
, CONCAT( DAY(str_to_date(`exp_newsbook`,'%d/%m/%Y')) ,'/', MONTH(str_to_date(`exp_newsbook`,'%d/%m/%Y')) ,'/', YEAR(str_to_date(`exp_newsbook`,'%d/%m/%Y'))+543 ) AS 'cv_exp_newsbook'
FROM `data_newsbook` WHERE `stt_newsbook`=0 ORDER BY `id_newsbook` DESC ";
$qr_data = mysqli_query($con_db_main,$sql_data) or die( mysqli_error($con_db_main));
}
}else{
echo "<SCRIPT type='text/javascript'>
alert('กรุณาเข้าสู่ระบบ [1]');
window.location.replace('topNewsbook');
</SCRIPT>";
exit;
}
?>
<!doctype html>
<html lang="en">
<head>
<?php include_once ("head.html"); ?>
</head>
<body class="bg-all bg-white">
<!--------------------------------------------------------------------- MENU ---------------------------------------------------------->
<div class="container-fluid p-0 bg-body-tertiary shadow-sm" >
<div class="container p-0 fix-page" >
<div class="clearfix h-100 pt-2 pb-1" >
<div class="float-start m-auto"><a class="link-dark" href="index" >
<img class="img-fluid me-2" src="img/logo.png" style="max-height: 35px;margin-top:-6px;"><span class="fw-700 fs-20">องค์การบริหารส่วนตำบลสัมปทวน</span></a>
</div>
<div class="float-end pt-1"><a class="link-dark" >
<span class="fw-300 fs-16"><b>หน่วยงาน:</b> <span class="text-primary"><?php echo $rs_user['name_newsbookmb']; ?></span></span>
<span class="fw-300 fs-16 ps-2 pe-2"><b>ชื่อผู้ใช้งาน:</b> <span class="text-primary"><?php echo $rs_user['user_newsbookmb']; ?></span></span>
<span class="fw-300 fs-16 ps-2" style="border-left: 1px solid #6d7272;"><a class="link-dark" href="action/logout_newbook"><i class="fas fa-sign-out-alt" ></i> ออกจากระบบ</a></span>
</div>
</div>
</div>
</div>
<!-------------------------------------------------------------------------------------------------------------------------------------->
<div class="container pt-4 pb-4 fix-page" >
<div class="row">
<div class="col-auto ">
<span class="fs-36 fcr-gray fw-700 lh-sm">ระบบ Back Office</span>
</div>
<div class="col m-auto " >
<div class="bg-line-1 mt-2"></div>
</div>
<div class="w-100"></div>
<div class="col pt-3" >
<div class="w-100 overflow-x-auto">
<table class="table table-bordered table-striped table-hover mb-2 tball-mw">
<thead >
<tr class="text-center ">
<td style="width:15%">หน่วยงาน</td>
<td style="width:10%">เลขที่หนังสือ</td>
<td style="width:68%">เรื่อง</td>
<td style="width:7%"></td>
</tr>
</thead>
<tbody class="table-group-divider fs-16">
<?php
$c_row = 0;
while($rs_data = mysqli_fetch_array($qr_data)){
$id_newsbook=$rs_data["id_newsbook"];
$data_namembnewsbook_array = explode(", ", $rs_data["namemb_newsbook"] );
// print_r($data_namembnewsbook_array);
if (in_array( $namemb_newsbook , $data_namembnewsbook_array)){
$c_row++;
?>
<tr class="fw-500">
<td class="text-center" ><?php echo $rs_data["namemb_newsbook"];?></td>
<td class="text-center"><?php echo $rs_data["number_newsbook"];?></td>
<td style="background-color:#fffbe6;"><a href="#" role="button" class="fw-500" data-bs-toggle="modal" data-bs-target="#<?php echo $rs_data['number_newsbook']; ?>Modal"><?php echo $rs_data["name_newsbook"];?></a></td>
<td class="text-center">
<a href="#" role="button" class="link-danger fw-500" data-bs-toggle="modal" data-bs-target="#<?php echo $rs_data['number_newsbook']; ?>Modal"><i class="fas fa-file-alt me-1"></i>ดูข้อมูล</a>
<div class="modal fade" id="<?php echo $rs_data['number_newsbook']; ?>Modal" tabindex="-1" aria-labelledby="<?php echo $rs_data['number_newsbook']; ?>ModalLabel" aria-hidden="true">
<div class="modal-dialog modal-dialog-centered modal-lg">
<div class="modal-content">
<div class="modal-header">
<span class="modal-title fs-30 fw-500" id="<?php echo $rs_data['number_newsbook']; ?>ModalLabel">ข้อมูลระบบ Back Office</span>
<button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
</div>
<div class="modal-body p-4 mt-2">
<div class="row mb-2">
<span class="col-md-2 fw-500 m-auto text-end">เลขที่หนังสือ</span >
<div class="col-md-10">
<input type="text" class="form-control fw-300" value="<?php echo $rs_data['number_newsbook']; ?>" readonly>
</div>
</div>
<div class="row mb-2">
<span class="col-md-2 fw-500 m-auto text-end">หน่วยงาน</span >
<div class="col-md-10">
<input type="text" class="form-control fw-300" value="<?php echo $rs_data['namemb_newsbook']; ?>" readonly>
</div>
</div>
<div class="row mb-2">
<span class="col-md-2 fw-500 m-auto text-end">เรื่อง</span >
<div class="col-md-10">
<input type="text" class="form-control fw-300" value="<?php echo $rs_data["name_newsbook"]; ?>" readonly>
</div>
</div>
<div class="row mb-4">
<span class="col-md-2 fw-500 m-auto text-end">ระยะเวลา</span >
<div class="col-md-10">
<input type="text" class="form-control fw-300" value="<?php echo $rs_data["cv_date_newsbook"]; ?> - <?php echo $rs_data["cv_exp_newsbook"]; ?>" readonly>
</div>
</div>
<?php
$sql_cfiledoc = "SELECT COUNT(*) FROM `data_filedoc_newsbook` WHERE `id_tbdata_filedoc_newsbook`='$id_newsbook' ";
$qr_cfiledoc = mysqli_query($con_db_main, $sql_cfiledoc) or trigger_error("SQL", E_USER_ERROR);
$rs_cfiledoc = mysqli_fetch_row($qr_cfiledoc);
$sql_data_filedoc = "SELECT * FROM `data_filedoc_newsbook` WHERE `id_tbdata_filedoc_newsbook`='$id_newsbook' ";
$qr_data_filedoc = mysqli_query($con_db_main,$sql_data_filedoc) or die( mysqli_error($con_db_administrator));
?>
<div class="row mb-2">
<span class="col-md-2 fw-500 text-end">ไฟล์เอกสาร</span>
<div class="col-md-10 text-start fw-300">
<?php
while($rs_data_filedoc = mysqli_fetch_array($qr_data_filedoc)){
echo '<a target="_blank" href="../'.$rs_data_filedoc['path_filedoc_newsbook'].'"class="link-danger"><i class="fas fa-download me-1"></i> '.$rs_data_filedoc['name_filedoc_newsbook'].'</a>';
echo '<br>';
}
?>
</div>
</div>
</div>
</div>
</div>
</div>
</td>
</tr>
<?php
}
}
?>
<?php
if( $c_row == 0 ){ echo '<tr><td colspan="8"><div class="w-100 text-center mt-5 mb-5 text-secondary opacity-50 fs-20 fw-300 lh-sm" ><i class="fas fa-eye-slash fs-70 pb-3"></i><br>ไม่พบข้อมูลระบบ Back Office<br>หน่วยงาน '.$rs_user['name_newsbookmb'].'</div></td></tr>';}
?>
</tbody>
</table>
</div>
<div class="fw-300 fs-12 w-100 text-secondary lh-sm text-end">
ข้อมูลทั้งหมด <span class="text-danger"><b><?php echo $c_row; ?></b></span> ข้อมูล
</div>
</div>
</div>
<div class="row mt-3">
<div class="col m-auto" >
<div class="bg-line-1"></div>
</div>
</div>
<div class="w-100 text-center mt-3 lh-sm text-secondary fs-11 fw-300" >
@2024 All right reserved, Sumpatuan Subdistrict Administrative Organization<br class="showTab">design and development by Information Design Co.,Ltd.
</div>
</div>
</body>
</html>