| Server IP : 103.233.192.212 / Your IP : 3.141.202.216 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/admin/data/ |
Upload File : |
<?php
require_once('session_backend_administrator.php');
header('Content-Type: text/html; charset=UTF-8');
if($STT_login=="admin_login_true"){
$check_id = $con_db_administrator->real_escape_string($_GET['id']);
$check_name = $con_db_administrator->real_escape_string($_GET['name']);
if( $check_id=="" or !isset($check_id) or $check_name=="" or !isset($check_name) ){
echo "<SCRIPT type='text/javascript'>
alert('ไม่พบข้อมูลที่ต้องการแก้ไข');
window.location.replace('../index');
</SCRIPT>";
exit;
}else{
$sql_data = "SELECT * , CONCAT( DAY(str_to_date(`lastupdate_agency`,'%d/%m/%Y')) ,'/', MONTH(str_to_date(`lastupdate_agency`,'%d/%m/%Y')) ,'/', YEAR(str_to_date(`lastupdate_agency`,'%d/%m/%Y'))+543 ) AS 'cv_lastupdate_agency'
FROM `data_agency` WHERE `id_agency`='$check_id' AND `name_agency`='$check_name' ";
$qr_data = mysqli_query($con_db_administrator,$sql_data) or die( mysqli_error($con_db_administrator));
$rs_data = mysqli_fetch_array($qr_data);
if( empty($rs_data) ){
echo "<SCRIPT type='text/javascript'>
alert('ไม่ข้อมูล ที่ต้องการแก้ไข');
window.location.replace('Agency');
</SCRIPT>";
exit;
}
$id_agency = $rs_data["id_agency"];
$stt_data = $rs_data["stt_agency"];
$sql_cpwimg = "SELECT COUNT(*) FROM `data_filedoc_agency` WHERE `id_tbdata_filedoc_agency`='$id_agency' ";
$qr_cpwimg = mysqli_query($con_db_administrator, $sql_cpwimg) or trigger_error("SQL", E_USER_ERROR);
$rs_cpwimg = mysqli_fetch_row($qr_cpwimg);
}
}else{
echo "<SCRIPT type='text/javascript'>
alert('กรุณาเข้าสู่ระบบ');
window.location.replace('../index');
</SCRIPT>";
exit;
}
?>
<!doctype html>
<html lang="en">
<head>
<?php include_once ("head.html"); ?>
</head>
<body class="" >
<?php include_once ("menu.php"); ?>
<div class="container pt-3 pb-4">
<div class="row ">
<div class="col text-secondary" >
<div class="p-1 ps-2 box-link " ><a href="../backend-administrator" class="link-info">หน้าหลัก</a> / <a href="Agency" class="link-info">หน่วยงานและอำนาจหน้าที่</a> / แก้ไขข้อมูล <?php echo $rs_data["name_agency"];?></div>
</div>
<div class="w-100 pb-4"></div>
<div class="col m-auto" >
<div class="bg-line-1 hideTab"></div>
</div>
<div class="col-auto text-center">
<span class="lh-sm h2 fw-700">แก้ไขข้อมูล <?php echo $rs_data["name_agency"];?></span>
</div>
<div class="col m-auto" >
<div class="bg-line-1 hideTab"></div>
</div>
</div>
<div class="row mt-3 mb-4 p-2">
<div class="col box-data p-4">
<form action="action/save-Agency-edit" name='form_Agency_Edit' id='form_Agency_Edit' method="post" enctype="multipart/form-data">
<div class="row mb-4">
<label class="col-2 col-form-label fw-700 txtbox-align">ลำดับ</label>
<div class="col-10">
<input type="text" class="form-control" name="edt_id" value="<?php echo $rs_data['id_agency']; ?>" oninput="this.value = this.value.replace(/\D+/g, '').replace(/^0[^.]/, '0');" maxlength="5" style="max-width:150px" required>
<input type="hidden" name="edt_oldid" value="<?php echo $rs_data['id_agency']; ?>" readonly>
</div>
</div>
<div class="row mb-4">
<label class="col-lg-2 col-form-label fw-700 txtbox-align">ชื่อหน่วยงาน</label>
<div class="col-lg-10">
<input type="text" class="form-control" name="edt_name" value="<?php echo $rs_data["name_agency"];?>" maxlength="200" required>
</div>
</div>
<div class="row mb-4">
<label class="col-lg-2 col-form-label fw-700 txtbox-align">รายละเอียด</label>
<div class="col-lg-10">
<textarea id="editor" name="edt_data" >
<?php echo $rs_data['data_agency']; ?>
</textarea>
</div>
</div>
<?php if($rs_cpwimg[0]>=1){ ?>
<div class="row mb-4">
<label class="col-lg-2 col-form-label fw-700 txtbox-align">ตัวอย่างรูปภาพ</label>
<div class="col-lg-10">
<?php
$sql_pwimg = "SELECT * FROM `data_filedoc_agency` WHERE `id_tbdata_filedoc_agency`='$id_agency' ";
$qr_pwimg = mysqli_query($con_db_administrator,$sql_pwimg) or die( mysqli_error($con_db_administrator));
if($rs_cpwimg[0]==1){
while($rs_pwimg = mysqli_fetch_array($qr_pwimg)){
echo '<div class="w-100 text-center bg-white border"><img src="../../'.$rs_pwimg['path_filedoc_agency'].'" class="img-fluid mh_1pic"></div>';
}
}else if($rs_cpwimg[0]>1){
echo '<div id="slideAB" class="carousel slide carousel-dark bg-white border" data-bs-ride="carousel">
<div class="carousel-inner">';
$c_row=0;
while($rs_pwimg = mysqli_fetch_array($qr_pwimg)){ $c_row++;
if($c_row==1){
echo '<div class="carousel-item active text-center animated fadeIn" data-bs-interval="2000">
<img src="../../'.$rs_pwimg['path_filedoc_agency'].'" class="img-fluid mh_pic">
</div>';
}else{
echo '<div class="carousel-item text-center animated fadeIn" data-bs-interval="2000">
<img src="../../'.$rs_pwimg['path_filedoc_agency'].'" class="img-fluid mh_pic">
</div>';
}
}
echo ' </div>
<button class="carousel-control-prev" type="button" data-bs-target="#slideAB" data-bs-slide="prev">
<span class="carousel-control-prev-icon" aria-hidden="true"></span>
<span class="visually-hidden">Previous</span>
</button>
<button class="carousel-control-next" type="button" data-bs-target="#slideAB" data-bs-slide="next">
<span class="carousel-control-next-icon" aria-hidden="true"></span>
<span class="visually-hidden">Next</span>
</button>
</div>';
};
?>
</div>
</div>
<hr class="hr-das mb-4">
<?php } ?>
<div class="row mb-4">
<label class="col-2 col-form-label fw-700 txtbox-align">สถานะ</label>
<div class="col-10">
<select class="form-select w-selec" name="statusshow">
<option value="0" <?php if($stt_data=="0"){ echo "selected"; }?>>แสดง</option>
<option value="1" <?php if($stt_data=="1"){ echo "selected"; }?>>ไม่แสดง</option>
</select>
</div>
</div>
<hr class="hr-das mb-3">
<div class="text-center">
<button type="submit" class="btn btn-success"><i class="fas fa-save me-2" ></i> บันทึกการแก้ไข</button>
<button type="button" onclick="location.href='Agency';" class="btn btn-danger ms-2">ย้อนกลับ</button>
<br><span class="fs-12 text-secondary fs-20 fw-300 ">แก้ไขล่าสุด : <?php echo $rs_data["cv_lastupdate_agency"];?></span>
</div>
</form>
</div>
<div class="w-100"></div>
<div class="col mx-auto box-data p-4 mt-4" >
<div class="fs-30 fw-700 text-center">จัดการไฟล์</div>
<ul class="nav nav-tabs" id="myTab" role="tablist">
<li class="nav-item" role="presentation">
<button class="nav-link active" id="img-tab" data-bs-toggle="tab" data-bs-target="#img-tab-pane" type="button" role="tab" aria-controls="img-tab-pane" aria-selected="true"><i class="fas fa-file-image"></i> อัพโหลดรูปภาพ</button>
</li>
</ul>
<div class="tab-content" id="myTabContent">
<div class="tab-pane fade show bg-white p-4 border mh_upload active " id="img-tab-pane" role="tabpanel" aria-labelledby="img-tab" tabindex="0" >
<div class="row">
<label class="col-auto col-form-label fw-700 txtbox-align">เพิ่มไฟล์รูปภาพ</label>
<div class="col">
<form action="action/save-addfiledoc-imgagency" name='form_imgagency' id='form_imgagency' method="post" enctype="multipart/form-data">
<input type="hidden" name="id_data_filedoc" value="<?php echo $id_agency;?>" readonly>
<div class="input-group mt-1">
<input type="file" class="form-control" id="uploadImg" name="uploadImg[]" aria-label="Upload" accept="image/png, image/gif, image/jpeg" multiple required>
<button type="submit" class="btn btn-primary"><i class="fas fa-cloud-download-alt"></i> อัพโหลดรูปภาพ</button>
</div>
<div class="mt-2 lh-base fs-14 text-secondary fw-300">
- อัพโหลดไฟล์รูปภาพ เพื่อนำไปเป็นสไลด์รูปภาพประกอบเนื้อหา
<br>- ถ้ามีรูปภาพเพียงรูปเดียว จะเป็นแสดงภาพสูงสุดที่ 600px
<br>- ถ้ามีรูปภาพหลายรูป จะเป็นภาพสไลด์ ตอนแสดงผล จะกำหนดไว้สูงสุดที่ 500px
</div>
</form>
</div>
</div>
<?php
$sql_cfileimg = "SELECT COUNT(*) FROM `data_filedoc_agency` WHERE `id_tbdata_filedoc_agency`='$id_agency' ";
$qr_cfileimg = mysqli_query($con_db_administrator, $sql_cfileimg) or trigger_error("SQL", E_USER_ERROR);
$rs_cfileimg = mysqli_fetch_row($qr_cfileimg);
$sql_data_fileimg = "SELECT * FROM `data_filedoc_agency` WHERE `id_tbdata_filedoc_agency`='$id_agency' ";
$qr_data_fileimg = mysqli_query($con_db_administrator,$sql_data_fileimg) or die( mysqli_error($con_db_administrator));
?>
<table class="mt-3 table table-sm table-striped table-bordered table-hover ">
<thead >
<tr class="text-center table-secondary fs-16">
<th style="width:94%">ไฟล์รูปภาพ <?php echo $rs_cfileimg['0'];?> รายการ</th>
<th style="width:6%">ลบ</th>
</tr>
</thead>
<tbody class="table-group-divider fs-16">
<?php while($rs_data_fileimg = mysqli_fetch_array($qr_data_fileimg)){ ?>
<tr>
<td><a href="<?php echo "../../".$rs_data_fileimg['path_filedoc_agency'];?>" target="_blank" class="link-danger"><i class="fas fa-file-image"></i> <?php echo $rs_data_fileimg['name_filedoc_agency'];?></a></td>
<td class="text-center fs-18" >
<a href="action/del-filedoc-agency?id=<?php echo $rs_data_fileimg['id_filedoc_agency'];?>&path=<?php echo $rs_data_fileimg['path_filedoc_agency'];?>" class="link-dark" data-bs-toggle="tooltip" data-bs-title="ลบข้อมูล" onclick="return confirm('ต้องการลบข้อมูล ใช่หรือไม่?');" ><i class="fas fa-trash-alt" ></i></a>
</td>
</tr>
<?php } ?>
<?php
if($rs_cfileimg[0]=="0"){ echo '<tr><td colspan="7"><div class="w-100 text-center mt-3 mb-3 text-secondary opacity-50 fs-16" ><i class="fas fa-eye-slash"></i>ไม่พบไฟล์รูปภาพ</div></td></tr>';}
?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<?php include_once ("../footer.php"); ?>
<script>
$('#uploadImg').change(function(){
if(this.files.length>10){
alert('อัพโหลดได้สูงสุดทีละ 10 ไฟล์ สามารถอัพโหลดเพิ่มภายหลังได้');
$("#uploadImg").val(null);
return false;
}
});
$('body').on('dragstart drop', function(e){
e.preventDefault();
return false;
});
</script>
<style>
.ck-editor__editable {
min-height: 250px;
}
</style>
<script>
ClassicEditor
.create( document.querySelector( '#editor' ), {
mediaEmbed: {
previewsInData: true
}
} )
.then( editor => {
window.editor = editor;
} )
.catch( error => {
console.error( error );
} );
</script>
</div>
</body>
</html>