Viewing file:  pdf_dashboard.php (16.52 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
ob_start();
session_start();
require_once('includes/db.php');
require_once('includes/f_thaidate.php');
if (!$_SESSION['fullname']) {
header("location: index.php");
}
?>
<!DOCTYPE html>
<html>
<head>
<title>Admin Dashboard : PHBCOOP</title>
<meta charset="utf-8">
<meta content="ie=edge" http-equiv="x-ua-compatible">
<meta content="Admin Dashboard" name="keywords">
<meta content="Phbcoop" name="author">
<meta content="Admin dashboard Phbcoop" name="description">
<meta content="width=device-width, initial-scale=1" name="viewport">
<link href="img/favicon_autosoft.png" rel="shortcut icon">
<link href="https://fonts.googleapis.com/css?family=Prompt:300,400,600,700,800%7CShadows+Into+Light%7CPlayfair+Display:400" rel="stylesheet" type="text/css">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/css/bootstrap.min.css" integrity="sha384-GJzZqFGwb1QTTN6wy59ffF1BuGJpLSa9DkKMp0DgiMDm4iYMj70gZWKYbI706tWS" crossorigin="anonymous">
<link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.6.3/css/all.css" integrity="sha384-UHRtZLI+pbxtHCWp1t77Bi1L4ZtiqrqD80Kn4Z8NTSRyMA2Fd33n5dQ8lWUE00s/" crossorigin="anonymous">
<link rel="stylesheet" href="https://code.jquery.com/ui/1.12.0/themes/smoothness/jquery-ui.css" type="text/css">
<link href="css/main.css?version=4.4.0" rel="stylesheet">
<link href="bower_components/select2/dist/css/select2.min.css" rel="stylesheet">
<link href="bower_components/bootstrap-daterangepicker/daterangepicker.css" rel="stylesheet">
<link href="bower_components/dropzone/dist/dropzone.css" rel="stylesheet">
<link href="bower_components/datatables.net-bs/css/dataTables.bootstrap.min.css" rel="stylesheet">
<link href="bower_components/fullcalendar/dist/fullcalendar.min.css" rel="stylesheet">
<link href="bower_components/perfect-scrollbar/css/perfect-scrollbar.min.css" rel="stylesheet">
<link href="bower_components/slick-carousel/slick/slick.css" rel="stylesheet">
<style>
.table .ui-sortable-helper {
background: #FFF;
box-shadow: 0px 0px 5px #000000;
width: 100%;
}
.modal-xl{
max-width: 1000px;
}
</style>
<body class="menu-position-side menu-side-left full-screen">
<div class="all-wrapper solid-bg-all">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.2.4/jquery.min.js"></script>
<div class="layout-w">
<!--------------------
START - Mobile Menu
-------------------->
<?php //include ('includes/mobile_menu.php');
?>
<!--------------------
START - Main Menu
-------------------->
<?php include('includes/main_menu.php'); ?>
<!--------------------
END - Main Menu
-------------------->
<div class="content-w">
<!--------------------
START - Top Bar
-------------------->
<?php include('includes/top_setting.php'); ?>
<!--------------------
END - Top Bar
-------------------->
<div class="content-i">
<div class="content-box">
<div class="row">
<div class="col-lg-12">
<div class="element-wrapper">
<div class="element-box">
<div class="content-i">
<div class="content-box">
<div class="row">
<?php
$r_id = isset($_GET['v_id']) ? $_GET['v_id'] : '1';
$result = $conn->prepare("SELECT categoryname FROM tbl_category where id = $r_id ");
$result->execute();
while ($val = $result->fetch()) {
?>
<div class="col-sm-12">
<div class="element-wrapper">
<div class="element-actions">
<a class="btn btn-success btn-md" href="pdf_form.php?v_id=<?php echo $r_id; ?>"><i class="os-icon os-icon-ui-22 os-icon-md"></i><span>เพิ่ม<?php echo $val['categoryname']; ?></span></a>
</div>
<h4 class="element-header">
เอกสาร PDF : <span class="text-info"><?php echo $val['categoryname']; ?> </span>
</h4>
<?php } ?>
<script>
$(document).ready(function(e) {
$('#sortable tbody').sortable({
handle: 'i.fa-arrows-alt',
placeholder: "ui-state-highlight",
//opacity: 0.9,
update: function() {
var order = $('#sortable tbody').sortable('toArray', {
attribute: 'data-sort-id'
});
console.log(order.join(','));
sortOrder = order.join(',');
$.post(
'action-form.ajax.php', {
'action': 'updateSortedRows',
'sortOrder': sortOrder,
'tables': 'tbl_pdf',
'whereField': 'no'
},
function(data) {
var a = data.split('|***|');
if (a[1] == "update") {
$('#msg').html(a[0]);
}
}
);
}
});
$("#sortable").disableSelection();
$('[data-toggle="tooltip"]').tooltip();
});
</script>
<div class="element-box">
<div class="table-responsive">
<div id="msg"></div>
<form id="form" method="post">
<input type="hidden" name="action" value="saveAddMore">
<table class="table table-lightborder" id="sortable">
<thead>
<tr>
<th class="text-center">
<H6>Sequence</H6>
</th>
<th>
<H6> ชื่อหัวข้อ Title name </H6>
</th>
<th class="text-center">
<H6> Action </H6>
</th>
</tr>
</thead>
<tbody id="tb">
<?php
$result = $conn->prepare("SELECT * FROM tbl_pdf where doc_cat = $r_id ORDER BY pin ASC ");
$result->execute();
if ($result->rowCount() > 0) {
while ($val = $result->fetch()) {
$id = $val['no'];
?>
<tr data-sort-id="<?php echo $val['no']; ?>">
<td align="center"><i class="fa fa-fw fa-arrows-alt" data-toggle="tooltip" title="Drag Up or Down"></i></td>
<td class="text-left">
<H6 class="lead"> <?php echo $val['doc_name']; ?></H6>
</td>
<td class="row-actions">
<div data-toggle="tooltip">
<a href="pdf_form_edit.php?r_id=<?php echo $id; ?>&&cat=<?php echo $r_id; ?>"><i class="os-icon os-icon-ui-49 text-success" data-title="แก้ไขรายการ" data-toggle="tooltip"></i></a>
<a class="info" href="#Info<?php echo $id; ?>" data-toggle="modal"><i class="os-icon os-icon-grid-10" data-title="ข้อมูล PDF" data-toggle="tooltip"></i></a>
<a class="danger" href="#DeletePerson<?php echo $id; ?>" data-toggle="modal"><i class="os-icon os-icon-ui-15" data-title="ลบรายการ" data-toggle="tooltip"></i></a>
<!-- Start Modal -->
<form method="post" action="delete_pdf.php?person_id=<?php echo $id; ?>&&r_id=<?php echo $r_id; ?>" enctype="multipart/form-data">
<div aria-hidden="true" aria-labelledby="exampleModalLabel" class="modal fade" id="DeletePerson<?php echo $id; ?>" role="dialog" tabindex="-1">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<h5 class="modal-title" id="exampleModalLabel">
ยืนยันการลบข้อมูล
</h5>
<button aria-label="Close" class="close" data-dismiss="modal" type="button"><span aria-hidden="true"> ×</span></button>
</div>
<div class="modal-body">
<div class="onboarding-media">
<img alt="" src="img/delete_user.png" width="200px">
</div>
<div class="onboarding-content with-gradient">
<h4 class="onboarding-title">
Are you Sure ?
</h4>
<p class="text-danger"> Delete : <?php echo $val['doc_name']; ?></p>
</div>
</div>
<div class="modal-footer">
<button class="btn btn-secondary" data-dismiss="modal" type="button"> Close</button><input class="btn btn-danger" type="submit" name="submitform" value="ลบข้อมูล" />
</div>
</div>
</div>
</div>
</form>
<!-- End Modal -->
<div aria-hidden="true" aria-labelledby="exampleModalLabel" class="modal fade bd-example-modal-xl" id="Info<?php echo $id; ?>" role="dialog" tabindex="-1">
<div class="modal-dialog modal-xl" role="document">
<div class="modal-content">
<div class="modal-header">
<button aria-label="Close" class="close" data-dismiss="modal" type="button"><span aria-hidden="true"> ×</span></button>
</div>
<div class="modal-body">
<div class="onboarding-content with-gradient">
<h4 class="onboarding-title">
<?php echo $val['doc_name']; ?>
</h4>
<p class="text-danger"><?php echo $val['doc_file']; ?></p>
<iframe src="docs/<?php echo $val['doc_file']; ?>" width="100%" height="700px"></iframe>
</div>
</div>
<div class="modal-footer">
<button class="btn btn-secondary" data-dismiss="modal" type="button"> Close</button>
</div>
</div>
</div>
</div>
</div>
</td>
</tr>
<?php
}
} else { ?>
<tr>
<td colspan="6" class="bg-light text-center"><strong>No Record(s) Found!</strong></td>
</tr>
<?php } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<!--END - Recent Ticket Comments-->
</div>
</div>
</div>
</div>
</div>
</div>
<div class="display-type"></div>
</div>
<script src="https://code.jquery.com/ui/1.12.0/jquery-ui.min.js" integrity="sha256-eGE6blurk5sHj+rmkfsGYeKyZx3M4bG+ZlFyA7Kns7E=" crossorigin="anonymous"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.6/umd/popper.min.js" integrity="sha384-wHAiFfRlMFy6i5SRaxvfOCifBUQy1xHdJ/yoi7FRNXMRBu5WHdZYu1hA6ZOblgut" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.2.1/js/bootstrap.min.js" integrity="sha384-B0UglyR+jN6CkvvICOB2joaf5I4l3gm9GU6Hc1og6Ls7i6U/mkkaduKaBhlAXv9k" crossorigin="anonymous"></script>
<script src="bower_components/bootstrap/js/dist/util.js"></script>
<script src="bower_components/bootstrap/js/dist/alert.js"></script>
<script src="bower_components/bootstrap/js/dist/button.js"></script>
<script src="bower_components/bootstrap/js/dist/carousel.js"></script>
<script src="bower_components/bootstrap/js/dist/collapse.js"></script>
<script src="bower_components/bootstrap/js/dist/dropdown.js"></script>
<script src="bower_components/bootstrap/js/dist/modal.js"></script>
<script src="bower_components/bootstrap/js/dist/tab.js"></script>
<script src="bower_components/bootstrap/js/dist/tooltip.js"></script>
<script src="bower_components/bootstrap/js/dist/popover.js"></script>
<script src="js/demo_customizer.js?version=4.4.0"></script>
<script src="js/main.js?version=4.4.0"></script>
</body>
</html>
|