Viewing file:  portfolio_one.php (14.29 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?
include 'index_IncludeAdmin.php';
$_SESSION['page'] = 'portfolio.php';
if (isset($_GET[portfolio_id])){
$_SESSION[portfolio_id] = $_GET[portfolio_id];
}
$portfolio_id = $_SESSION[portfolio_id] ;
if ($_POST['portfolio_pictureAdd']) {
if(isset($_FILES['portfolio_picture_photo']['name'])&&$_FILES['portfolio_picture_photo']['name']!=''){
$Count = count($_FILES['portfolio_picture_photo']['name']);
for ($i=0; $i < $Count; $i++) {
$portfolio_picture_photo = rand().$_FILES["portfolio_picture_photo"]["name"][$i];
if(move_uploaded_file($_FILES["portfolio_picture_photo"]["tmp_name"][$i],"../Files/portfolio_picture_photo/".$portfolio_picture_photo)){
$portfolio_picture_Add = "INSERT INTO `portfolio_picture` (`portfolio_id`,`portfolio_picture_photo`) VALUES ('$portfolio_id','$portfolio_picture_photo')";
$portfolio_picture_Reult = mysqli_query($con,$portfolio_picture_Add);
if (!$portfolio_picture_Reult) {
echo"<script>alert('Error portfolio_picture'); window.history.back(); </script>";
}
}
else{
echo"<script>alert('Error move_uploaded_file'); window.history.back(); </script>";
}
}
echo"<script> window.location='portfolio_one.php?INSERT'; </script>";
}
}
if ($_GET['portfolio_pictureDel']) {
$portfolio_picture_id = $_GET[portfolio_picture_id];
$portfolio_picture_SL = " SELECT * FROM portfolio_picture WHERE portfolio_picture_id = '$portfolio_picture_id'";
$portfolio_picture_QR = mysqli_query($con,$portfolio_picture_SL);
$portfolio_picture = mysqli_fetch_array($portfolio_picture_QR);
@unlink("../Files/portfolio_picture_photo/".$portfolio_picture['portfolio_picture_photo']);
$portfolio_picture_Del ="DELETE FROM `portfolio_picture` WHERE portfolio_picture_id = '$portfolio_picture_id' ";
$portfolio_picture_Qurey = mysqli_query($con,$portfolio_picture_Del);
if($portfolio_picture_Qurey) {
echo"<script> window.location='portfolio_one.php?DELETE'; </script>";
}
else{
echo"<script>alert('เกิดข้อผิดพลาด'); window.history.back(); </script>";
}
}
if ($_POST['portfolioUpdate']) {
if($_FILES['portfolio_photo']['name']!=''){
@unlink("../Files/portfolio_photo/".$portfolio['portfolio_photo']);
$file = rand().$_FILES["portfolio_photo"]["name"];
$upload = move_uploaded_file($_FILES["portfolio_photo"]["tmp_name"],"../Files/portfolio_photo/".$file);
$portfolio_photo_Update = "UPDATE `portfolio` SET `portfolio_photo` = '$file' WHERE `portfolio_id` = '$portfolio_id'";
$portfolio_photo_Reult = mysqli_query($con,$portfolio_photo_Update);
if (!$portfolio_photo_Reult) {
echo"<script>alert('เกิดข้อผิดพลาด'); window.history.back(); </script>";
}
if ($portfolio_photo_Reult) {
echo"<script> window.location='portfolio_one.php?UPDATE'; </script>";
}
}
}
$portfolio_SL = " SELECT * FROM portfolio WHERE portfolio_id = '$portfolio_id'";
$portfolio_QR = mysqli_query($con,$portfolio_SL);
$portfolio = mysqli_fetch_array($portfolio_QR);
?>
<!DOCTYPE html>
<html>
<head>
<? include 'index_Head.php'; ?>
</head>
<body>
<? include 'index_Navbar.php'; ?>
<div class="container-fluid">
<div class="row">
<div class="col-md-2" id="main-left">
<div class="row">
<div class="col-md-12">
<? include 'index_AdminMenu.php'; ?>
</div>
</div>
</div>
<div class="col-md-10">
<div class="row">
<div class="col-md-12">
<h3> ผลงาน : <span class="text-primary bold"> <?php echo $portfolio[portfolio_name]; ?> </span> </h3>
<hr>
</div>
</div>
<? include 'index_Alerts.php'; ?>
<div class="row">
<div class="col-md-12 br-margin2">
<a href="portfolio.php" class="btn btn-primary"><span class="glyphicon glyphicon-step-backward"></span> กลับ </a>
<a href="portfolio_update.php?portfolio_id=<?php echo $portfolio[portfolio_id]; ?>" class="btn btn-info"><span class="glyphicon glyphicon-wrench"></span> แก้ไข</a>
<a href="portfolio_del.php?portfolio_id=<?php echo $portfolio[portfolio_id]; ?>" onclick="return confirm(' ยืนยันการลบข้อมูล ? ')" class="btn btn-danger">
<span class="glyphicon glyphicon-remove-sign"></span> ลบ
</a>
</div>
<div class="col-md-8">
<div class="panel panel-default">
<div class="panel-heading">
รายละเอียดผลงาน : <span class="text-primary bold"> <?php echo $portfolio[portfolio_name]; ?> </span>
</div>
<div class="panel-body">
<div class="row br-margin2">
<div class="col-md-12">
<form class="form-horizontal">
<div class="form-group">
<label class="control-label col-md-3" > ชื่อ ผลงาน </label>
<label class="control-label col-md-9 text-left">
<? echo $portfolio[portfolio_name]; ?>
</label>
</div>
<div class="form-group">
<label class="control-label col-md-3" >รายละเอียดเบื้องต้น</label>
<label class="control-label col-md-9 text-left">
<? echo $portfolio[portfolio_detail]; ?>
</label>
</div>
<div class="form-group">
<label class="control-label col-md-3" > ผลงานของ </label>
<label class="control-label col-md-9 text-left">
<?
$salesteam_SL = " SELECT * FROM salesteam WHERE salesteam_id = '$portfolio[salesteam_id]'";
$salesteam_QR = mysqli_query($con,$salesteam_SL);
$salesteam = mysqli_fetch_array($salesteam_QR);
if (!isset($salesteam[salesteam_id])||$salesteam[salesteam_id]=='') {
?>
-
<?
}
else{
echo $salesteam[salesteam_name];
}
?>
</label>
</div>
<div class="form-group">
<label class="control-label col-md-3" >ลงข้อมูลเมื่อ</label>
<label class="control-label col-md-9 text-left">
<? echo displaydate($portfolio[portfolio_date]); ?>
</label>
</div>
</form>
</div>
</div>
<!-- row -->
</div>
<!-- panel body -->
</div>
<!-- panel -->
<div class="panel panel-default">
<div class="panel-heading">
เนื้อหา
</div>
<div class="panel-body">
<?php echo $portfolio[portfolio_review]; ?>
</div>
<div class="panel-footer">
แก้ไขล่าสุด : <?php echo $portfolio[portfolio_datetime]; ?>
</div>
</div>
</div>
<!-- 12 -->
<div class="col-md-4">
<div class="panel panel-default">
<div class="panel-heading">
<div class="row">
<div class="col-md-4">
จัดการรูปภาพ
</div>
<div class="col-md-8 text-right" style="margin: -5px;">
<button type="button" class="btn btn-sm btn-info " data-toggle="modal" data-target="#portfolioUpdate">
<span class="glyphicon glyphicon-picture"></span>
แก้ไขรูปภาพหลัก
</button>
<button type="button" class="btn btn-sm btn-success " data-toggle="modal" data-target="#portfolio_pictureAdd">
<span class="glyphicon glyphicon-picture"></span>
เพิ่มรูปภาพ
</button>
</div>
</div>
</div>
<div class="panel-body">
<div class="row">
<div class="col-md-12">
<p class="text-muted">
รูปภาพหลักของ ผลงาน
</p>
</div>
<div class="col-md-12 br-margin2">
<img class="full" style="cursor: zoom-in;" id="myImgmain<?php echo $portfolio[portfolio_id]; ?>" src="../Files/portfolio_photo/<?php echo $portfolio[portfolio_photo]; ?>" />
<div id="myModal" class="w3-modal">
<span class="zoom-close w3-close">×</span>
<img class="w3-modal-content w3-close" id="img01">
</div>
<script>
var w3modal = document.getElementById("myModal");
var img = document.getElementById("myImgmain<?php echo $portfolio[portfolio_id]; ?>");
var modalImg = document.getElementById("img01");
img.onclick = function(){
w3modal.style.display = "block";
modalImg.src = this.src;
}
var span = document.getElementsByClassName("w3-close")[0];
span.onclick = function() {
w3modal.style.display = "none";
}
window.onclick = function(event) {
if (event.target == w3modal) {
w3modal.style.display = "none";
}
}
</script>
</div>
</div>
<div class="row">
<?
$portfolio_picture_SL = " SELECT * FROM portfolio_picture WHERE portfolio_id = '$portfolio[portfolio_id]'";
$portfolio_picture_QR = mysqli_query($con,$portfolio_picture_SL);
$portfolio_picture_Row = mysqli_num_rows($portfolio_picture_QR);
if ($portfolio_picture_Row == '0') {
?>
<div class="col-md-12">
<p class="text-muted">
ยังไม่มีรูปภาพเพิ่มเติม
</p>
</div>
<?
}
else{
?>
<div class="col-md-12">
<p class="text-muted">
รูปภาพเพิ่มเติมของ ผลงาน
</p>
</div>
<?
}
while ($portfolio_picture = mysqli_fetch_array($portfolio_picture_QR)) {
?>
<div class="col-md-6">
<div class="thumbnail">
<div class="img80">
<img style="cursor: zoom-in;" id="myImg<?php echo $portfolio_picture[portfolio_picture_id]; ?>" src="../Files/portfolio_picture_photo/<?php echo $portfolio_picture[portfolio_picture_photo]; ?>" />
<div id="myModal" class="w3-modal">
<span class="zoom-close w3-close">×</span>
<img class="w3-modal-content w3-close" id="img01">
</div>
<script>
var w3modal = document.getElementById("myModal");
var img = document.getElementById("myImg<?php echo $portfolio_picture[portfolio_picture_id]; ?>");
var modalImg = document.getElementById("img01");
img.onclick = function(){
w3modal.style.display = "block";
modalImg.src = this.src;
}
var span = document.getElementsByClassName("w3-close")[0];
span.onclick = function() {
w3modal.style.display = "none";
}
window.onclick = function(event) {
if (event.target == w3modal) {
w3modal.style.display = "none";
}
}
</script>
</div>
<div class="caption">
<a href="portfolio_one.php?portfolio_picture_id=<?php echo $portfolio_picture[portfolio_picture_id]; ?>&portfolio_pictureDel=x" onclick="return confirm('ยืนยันการลบข้อมูล ? ')" ><span class="glyphicon glyphicon-remove-sign"></span> ลบรูปนี้</a>
</div>
</div>
</div>
<?
}
?>
</div>
</div>
</div>
</div>
<!-- 12 -->
</div>
<!-- row -->
</div>
<!-- 10 -->
</div>
<!-- row -->
</div>
<!-- container -->
<div id="portfolio_pictureAdd" class="modal fade" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<form class="form" enctype="multipart/form-data" method="post">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title" id="exampleModalLabel">เพิ่มรูปภาพเพิ่มเติม</h4>
</div>
<div class="modal-body">
<div class="form-group">
<label for="recipient-name" class="control-label">เลือกรูปภาพ <span class="text-muted normal">เป็นรูปภาพที่จะแสดงต่อจาก รูปหลักของ ผลงาน</span></label>
<input type="file" required class="form-control" multiple="multiple" name="portfolio_picture_photo[]">
</div>
</div>
<div class="modal-footer">
<button type="submit" class="btn btn-success">
<span class="glyphicon glyphicon-plus-sign"></span> ยืนยันการเพิ่ม
</button>
<input type="hidden" name="portfolio_pictureAdd" value="x">
<button type="button" class="btn btn-default" data-dismiss="modal">ยกเลิก</button>
</div>
</form>
</div>
</div>
</div>
<div id="portfolioUpdate" class="modal fade" role="dialog">
<div class="modal-dialog">
<div class="modal-content">
<form class="form" enctype="multipart/form-data" method="post">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title" id="exampleModalLabel">แก้ไขรูปภาพหลักของ ผลงาน</h4>
</div>
<div class="modal-body">
<div class="form-group">
<label for="recipient-name" class="control-label">เลือกรูปภาพ <span class="text-muted normal">เป็นรูปภาพที่จะนำมาแทนรูปเดิม</span></label>
<input type="file" required class="form-control" multiple="multiple" name="portfolio_photo">
</div>
</div>
<div class="modal-footer">
<button onclick="return confirm('ยืนยันการแก้ไข ? ')" type="submit" class="btn btn-success">
<span class="glyphicon glyphicon-floppy-disk"></span> บันทึกการแก้ไข
</button>
<input type="hidden" name="portfolioUpdate" value="x">
<button type="button" class="btn btn-default" data-dismiss="modal">ยกเลิก</button>
</div>
</form>
</div>
</div>
</div>
</body>
</html>
|