| Server IP : 103.233.192.212 / Your IP : 18.190.158.12 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_type = $con_db_administrator->real_escape_string($_GET['type']);
$check_id = $con_db_administrator->real_escape_string($_GET['id']);
$check_link = $con_db_administrator->real_escape_string($_GET['link']);
if(!isset($check_id) or $check_id=="" or !isset($check_type) or $check_type=="" or !isset($check_link) or $check_link=="" ){
echo "<SCRIPT type='text/javascript'>
alert('ไม่พบข้อมูล ที่ต้องการแก้ไข');
window.location.replace('../index');
</SCRIPT>";
exit;
}else{
$sql_data = " SELECT * FROM `data_plan` WHERE `id_plan`='$check_id' ";
$qr_data = mysqli_query($con_db_administrator, $sql_data);
$rs_data = mysqli_fetch_assoc($qr_data);
if( empty($rs_data) ){
echo "<SCRIPT type='text/javascript'>
alert('ไม่ข้อมูล ที่ต้องการแก้ไข');
window.location.replace('Plan?view=$check_link');
</SCRIPT>";
exit;
}
$id_plan = $rs_data['id_plan'];
$name_plan = $rs_data['name_plan'];
$stt_plan = $rs_data['stt_plan'];
}
}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="Plan?view=<?php echo $check_link;?>" class="link-info"><?php echo $check_type;?></a> / แก้ไขข้อมูล <?php echo $check_type;?></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 h1 fw-700">แก้ไขข้อมูล <br class="showTab"><?php echo $check_type;?></span>
</div>
<div class="col m-auto" >
<div class="bg-line-1 hideTab"></div>
</div>
</div>
<div class="row mt-4 mb-5 p-2">
<div class="col mx-auto box-data p-4" style="max-width:800px">
<form action="action/save-Plan-edit" name='form_Plan_edit' id='form_Plan_edit' method="post" enctype="multipart/form-data">
<input type="hidden" name="edt_id" value="<?php echo $rs_data['id_plan'];?>" readonly>
<input type="hidden" name="edt_type" value="<?php echo $rs_data['type_plan'];?>" readonly>
<input type="hidden" name="linkplan" value="Plan?view=<?php echo $check_link;?>" readonly>
<?php
$date = str_replace('/', '-', $rs_data["lastupdate_plan"]);
$date_plan = date("Y-m-d",strtotime($date));
?>
<div class="row mb-3">
<label class="col-lg-2 col-form-label fw-700 txtbox-align">วันที่ลง</label>
<div class="col-lg-10">
<input type="date" class="form-control w-selec" id="edt_date" name="edt_date" data-date-format="DD MMMM YYYY" value="<?php echo $date_plan; ?>" style="max-width:150px" required>
</div>
</div>
<hr class="hr-das mb-4">
<div class="row mb-4">
<label class="col-md-2 col-form-label fw-700 txtbox-align">ประจำปี</label>
<div class="col-md-10">
<input type="text" class="form-control" name="edt_year" value="<?php echo $rs_data['year_plan'];?>" style="max-width:150px" required/>
</div>
</div>
<div class="row mb-4">
<label class="col-md-2 col-form-label fw-700 txtbox-align">หัวข้อ</label>
<div class="col-md-10">
<input type="text" class="form-control" name="edt_name" value="<?php echo $rs_data['name_plan'];?>" required>
</div>
</div>
<div class="row mb-4">
<label class="col-md-2 col-form-label fw-700 txtbox-align">ประเภทแผน</label>
<div class="col-md-10">
<input type="text" class="form-control " value="<?php echo $rs_data['type_plan'];?>" disabled readonly>
</div>
</div>
<hr class="hr-das mb-4">
<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_plan=="0"){ echo "selected"; }?>>แสดง</option>
<option value="1" <?php if($stt_plan=="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" class="btn btn-danger ms-2" onclick="location.href='Plan?view=<?php echo $check_link;?>'">ย้อนกลับ</button>
</div>
</form>
</div>
<div class="w-100"></div>
<div class="col mx-auto box-data p-4 mt-3" style="max-width:800px">
<span class="fs-18 fw-700 text-center">ไฟล์ที่เกี่ยวข้อง <i class="fas fa-caret-square-right"></i> <br><?php echo $rs_data['name_plan'];?></span>
<?php
$sql_cfiledoc = "SELECT COUNT(*) FROM `data_filedoc` WHERE `id_tbdata_filedoc`='$id_plan' AND `tbdata_filedoc`='data_plan' ";
$qr_cfiledoc = mysqli_query($con_db_administrator, $sql_cfiledoc) or trigger_error("SQL", E_USER_ERROR);
$rs_cfiledoc = mysqli_fetch_row($qr_cfiledoc);
$sql_data_filedoc = "SELECT * FROM `data_filedoc` WHERE `id_tbdata_filedoc`='$id_plan' AND `tbdata_filedoc`='data_plan' ";
$qr_data_filedoc = mysqli_query($con_db_administrator,$sql_data_filedoc) or die( mysqli_error($con_db_administrator));
?>
<table class="table table-sm table-bordered table-bordered table-hover mt-2 mb-2">
<thead >
<tr class="text-center table-secondary fs-16">
<th style="width:90%">ไฟล์ที่เกี่ยวข้อง <?php echo $rs_cfiledoc[0]; ?> รายการ</th>
<th style="width:10%">ลบ</th>
</tr>
</thead>
<tbody class="table-group-divider fs-16">
<?php while($rs_data_filedoc = mysqli_fetch_array($qr_data_filedoc)){ ?>
<tr>
<td><a href="<?php echo "../../".$rs_data_filedoc['path_filedoc'];?>" target="_blank" class="link-danger"><i class="fas fa-file-alt" ></i> <?php echo $rs_data_filedoc['name_filedoc'];?></a></td>
<td class="text-center fs-18" >
<a href="action/del-filedoc-plan?id=<?php echo $rs_data_filedoc['id_filedoc'];?>&path=<?php echo $rs_data_filedoc['path_filedoc'];?>" 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_cfiledoc[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>
<hr class="hr-das mt-4">
<div class="mt-3">
<small class="fw-700">เพิ่มไฟล์ที่เกี่ยวข้อง</small>
<form action="action/save-addfiledoc-plan" name='form_Plan_addfiledoc' id='form_Plan_addfiledoc' method="post" enctype="multipart/form-data">
<input type="hidden" name="tb_data_filedoc" value="data_plan" readonly>
<input type="hidden" name="id_data_filedoc" value="<?php echo $rs_data['id_plan'];?>" readonly>
<div class="input-group mt-1">
<input type="file" class="form-control" id="uploadFile" name="uploadFile[]" aria-label="Upload" accept="image/png, image/gif, image/jpeg, application/pdf,application/msword,application/vnd.openxmlformats-officedocument.wordprocessingml.document,application/vnd.ms-excel,application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" multiple required>
<button type="submit" class="btn btn-dark" ><i class="fas fa-cloud-download-alt"></i> อัพโหลด</button>
</div>
</form>
<div class="mt-2 lh-sm">
<small class="fs-12 text-secondary">- เปลี่ยนชื่อไฟล์ให้เกี่ยวข้องกับหัวข้อ (ชื่อห้ามซ้ำกัน) ก่อนทำการเลือกไฟล์อัพโหลด</small>
<br><small class="fs-12 text-secondary">- อัพโหลดได้เฉพาะไฟล์รูปภาพ , .pdf , .doc/.docx , .xls/.xlsx</small>
</div>
</div>
</div>
</div>
<?php include_once ("../footer.php"); ?>
<script>
$('#uploadFile').change(function(){
if(this.files.length>10){
alert('อัพโหลดได้สูงสุดทีละ 10 ไฟล์ สามารถอัพโหลดเพิ่มภายหลังได้');
$("#uploadFile").val(null);
return false;
}
});
$('body').on('dragstart drop', function(e){
e.preventDefault();
return false;
});
</script>
</div>
</body>
</html>