<?php include('connect.php'); // Set session session_start(); $perpage = 5; if (isset($_GET['page'])) { $page = $_GET['page']; } else { $page = 1; } $start = ($page - 1) * $perpage; $sql = "select * from tb_criminal1 limit {$start} , {$perpage} "; $query = mysqli_query($con, $sql); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0"> <title>Electronic Data Systerm(EDS)</title> <link rel="stylesheet" href="assets/calendar/fullcalendar-3.6.2/fullcalendar.min.css"> <link rel="preconnect" href="https://fonts.gstatic.com"> <link href="https://fonts.googleapis.com/css2?family=Nunito:wght@300;400;600;700;800&display=swap" rel="stylesheet"> <link rel="stylesheet" href="assets/css/bootstrap.css"> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css"> <link rel="stylesheet" href="assets/vendors/iconly/bold.css"> <link rel="stylesheet" href="assets/vendors/perfect-scrollbar/perfect-scrollbar.css"> <link rel="stylesheet" href="assets/vendors/bootstrap-icons/bootstrap-icons.css"> <link rel="stylesheet" href="assets/vendors/bootstrap-icons/bootstrap-icons.css"> <link rel="stylesheet" href="assets/css/app.css"> <link rel="shortcut icon" href="assets/images/favicon.svg" type="image/x-icon"> <link rel="stylesheet" href="/assets/css/style.css"> <style> .rcorners4 { border-radius: 15px; background: #435ebe; padding: 20px; width: auto; height: 40px; } </style> </head> <?php require 'menu.php'; ?> <body> <?php require 'navigation.php'; ?> <div class="page-heading"> </div> <div class="page-content"> <section class="row"> <div class="col-12 "> <?php if($_SESSION["Oper_id"] =="11"){ ?> <a href="arrest-warrant.php"><button type="button" class="btn btn-success ">+บันทึกข้อมูลผู้ต้องหา</button></a> <a href="arrest-warrant.php"><button type="button" class="btn btn-primary ">+บันทึกข้อมูลการตรวจค้น</button></a> <?php } ?> <br/><br/> <div> </div> <div class="row"> <div class="col-2"> <div class="card"> <div class="card-header"> <h4>เลือกชนิดการจับกุม</h4> </div> <div class="card-body"> <div class="row"> <table> <th> <tr> <td><input type="checkbox" name="group1" id="group1" class="form-check-input" > </input></td> <td>จับกุมซึ่งหน้า</td> </tr> <tr> <td><input type="checkbox" name="group2" id="group1" class="form-check-input" > </input></td> <td>จับกุมตามหมายจับ</td> </tr> </th> </table> </div> </div> </div> </div> <div class="col-10"> <div class="card"> <div class="card-header" align="center"> <h4>เลือกกลุ่มฐานความผิด</h4> </div> <div class="card-body"> <div class="row"> <table> <th> <tr> <td><input type="checkbox" name="group1" id="group1" class="form-check-input" > </input></td> <td>กลุ่ม1 ฐานความผิดเกี่ยวกับชีวิต ร่างกาย ฯ </td> <td> </td> <td><input type="checkbox" name="group4" id="group1" class="form-check-input" > </input></td> <td>กลุ่ม4 ฐานความผิดที่รัฐเป็นผู้เสียหาย</td> <td> </td> <td rowspan="3">วันที่</td> <td rowspan="3"><input type="date" name="start_date" id="start_date" class="form-control" > </input></td> <td rowspan="3">ถึง</td> <td rowspan="3">วันที่</td> <td rowspan="3"><input type="date" name="end_date" id="end_date" class="form-control" > </input></td> </tr> <tr> <td><input type="checkbox" name="group2" id="group1" class="form-check-input" > </input></td> <td>กลุ่ม2 ฐานความผิดเกี่ยวกับทรัพย์</td> <td> </td> <td><input type="checkbox" name="group5" id="group1" class="form-check-input" > </input></td> <td>กลุ่ม5 ฐานความผิดอื่นๆ</td> </tr> <tr> <td><input type="checkbox" name="group3" id="group1" class="form-check-input" > </input></td> <td>กลุ่ม3 ฐานความผิดพิเศษ</td> <td> </td> </tr> <tr align="center"> <td colspan="11"> </br> <div class="input-group" style="width: 750px" align="center"> <input type="text" class="form-control form-control-lg" placeholder="ใส่คำที่ต้องการค้นหา" > <button class="btn-lg btn-primary" type="submit"> ค้นหา </button> </div> </td> </tr> </th> </table> </div> </div> </div> </div> </div> <div class="col-12"> <div class="card"> <div class="card-content"> <div class="card-body"> <!-- Table with outer spacing --> <div style="font-size:auto"> <div class="table-responsive"> <h4 class="card-title" >ข้อมูลผู้ต้องหา</h4> <table class="table " style="width=auto"> <tr> <th width="auto" style="background-color:#435ebe;color:white;border-radius: 8px 0 0 8px"> <div align="left">ลำดับ</div></th> <th width="auto" style="background-color:#435ebe;color:white"> <div align="center">วันที่จับกุม</div></th> <th width="auto" style="background-color:#435ebe;color:white"> <div align="center">ชื่อ-นามสกุล (ผตห.)</div></th> <th width="50px" style="background-color:#435ebe;color:white"> <div align="center">อายุ </div></th> <th width="auto" style="background-color:#435ebe;color:white"> <div align="center">เพศ </div></th> <th width="auto" style="background-color:#435ebe;color:white"> <div align="center">รหัสบัตรประชาชน </div></th> <th width="100px" style="background-color:#435ebe;color:white"> <div align="center">ที่อยู่ </div></th> <th width="auto" style="background-color:#435ebe;color:white"> <div align="center">ฐานความผิด </div></th> <th width="auto" style="background-color:#435ebe;color:white"> <div align="center"> ประเภทจับกุม</div></th> <th width="auto" style="background-color:#435ebe;color:white"> <div align="left">ภาพถ่าย </div></th> <th width="auto" style="background-color:#435ebe;color:white"> <div align="left">วิดีโอ </div></th> <th width="auto" style="background-color:#435ebe;color:white"> <div align="left">เอกสาร </div></th> <th width="auto" style="background-color:#435ebe;color:white"> <div align="left">เรียกดู </div></th> <th width="auto" style="background-color:#435ebe;color:white;border-radius: 0 8px 8px 0"> <div align="left">ลบ </div></th> </tr> <?php $i=1; if($page > 1){ $i = ($perpage * ($page-1)) + 1; } while($result=mysqli_fetch_array($query,MYSQLI_ASSOC)) { if($result["type_arrest"]=="1"){ $type_arrest_result="จับกุมซึ่งหน้า"; }else{ $type_arrest_result="จับกุมตามหมายจับ"; } ?> <tr> <td><div align="center"><?php echo $i;?></div></td> <td width="120px"><div align="left"><?php echo $result["catch_date"];?></div></td> <td><div align="left"><?php echo $result["name_title"].$result["criminal_fname"]." ".$result["criminal_lname"];?></div></td> <td width="auto"><div align="center"><?php echo $result["age"];?> ปี</div></td> <td><div align="left"><?php echo $result["gender"];?></div></td> <td><div align="left"><?php echo $result["id_card"];?></div></td> <td width="auto" align="left" ><?php echo 'เลขที่'." ".$result["address_num"]." ".'หมู่'." ".$result["vilage"]." ".'ซ.'." ".$result["soi_num"]." ".'ถ.'." ".$result["road"]." ".'ต.'." ".$result["tumbol"]." ".'อ.'." ".$result["aumphur"]." ".'จ.'." ".$result["province"];?> </td> <td align="left"><?php echo $result["base_arrest"];?></td> <td align="left"><?php echo $type_arrest_result;?></td> <td align="left"><button type="button" class="btn btn-outline-primary" data-toggle="modal" data-target="#myModal"> <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-image" viewBox="0 0 16 16"> <path d="M6.002 5.5a1.5 1.5 0 1 1-3 0 1.5 1.5 0 0 1 3 0z"></path> <path d="M2.002 1a2 2 0 0 0-2 2v10a2 2 0 0 0 2 2h12a2 2 0 0 0 2-2V3a2 2 0 0 0-2-2h-12zm12 1a1 1 0 0 1 1 1v6.5l-3.777-1.947a.5.5 0 0 0-.577.093l-3.71 3.71-2.66-1.772a.5.5 0 0 0-.63.062L1.002 12V3a1 1 0 0 1 1-1h12z"></path> </svg></button></td> <td align="left"><button type="button" class="btn btn-outline-primary"> <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-film" viewBox="0 0 16 16"> <path d="M0 1a1 1 0 0 1 1-1h14a1 1 0 0 1 1 1v14a1 1 0 0 1-1 1H1a1 1 0 0 1-1-1V1zm4 0v6h8V1H4zm8 8H4v6h8V9zM1 1v2h2V1H1zm2 3H1v2h2V4zM1 7v2h2V7H1zm2 3H1v2h2v-2zm-2 3v2h2v-2H1zM15 1h-2v2h2V1zm-2 3v2h2V4h-2zm2 3h-2v2h2V7zm-2 3v2h2v-2h-2zm2 3h-2v2h2v-2z"></path> </svg></button></td> <td align="left"><button type="button" class="btn btn-outline-primary"> <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-file-earmark-word-fill" viewBox="0 0 16 16"> <path d="M9.293 0H4a2 2 0 0 0-2 2v12a2 2 0 0 0 2 2h8a2 2 0 0 0 2-2V4.707A1 1 0 0 0 13.707 4L10 .293A1 1 0 0 0 9.293 0zM9.5 3.5v-2l3 3h-2a1 1 0 0 1-1-1zM5.485 6.879l1.036 4.144.997-3.655a.5.5 0 0 1 .964 0l.997 3.655 1.036-4.144a.5.5 0 0 1 .97.242l-1.5 6a.5.5 0 0 1-.967.01L8 9.402l-1.018 3.73a.5.5 0 0 1-.967-.01l-1.5-6a.5.5 0 1 1 .97-.242z"></path> </svg></button></td> <td align="left"><button type="button" class="btn btn-outline-primary"> <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-table" viewBox="0 0 16 16"> <path d="M0 2a2 2 0 0 1 2-2h12a2 2 0 0 1 2 2v12a2 2 0 0 1-2 2H2a2 2 0 0 1-2-2V2zm15 2h-4v3h4V4zm0 4h-4v3h4V8zm0 4h-4v3h3a1 1 0 0 0 1-1v-2zm-5 3v-3H6v3h4zm-5 0v-3H1v2a1 1 0 0 0 1 1h3zm-4-4h4V8H1v3zm0-4h4V4H1v3zm5-3v3h4V4H6zm4 4H6v3h4V8z"></path> </svg></button></td> <td align="left"><button type="button" class="btn btn-outline-danger"> <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor" class="bi bi-trash" viewBox="0 0 16 16"> <path d="M5.5 5.5A.5.5 0 0 1 6 6v6a.5.5 0 0 1-1 0V6a.5.5 0 0 1 .5-.5zm2.5 0a.5.5 0 0 1 .5.5v6a.5.5 0 0 1-1 0V6a.5.5 0 0 1 .5-.5zm3 .5a.5.5 0 0 0-1 0v6a.5.5 0 0 0 1 0V6z"></path> <path fill-rule="evenodd" d="M14.5 3a1 1 0 0 1-1 1H13v9a2 2 0 0 1-2 2H5a2 2 0 0 1-2-2V4h-.5a1 1 0 0 1-1-1V2a1 1 0 0 1 1-1H6a1 1 0 0 1 1-1h2a1 1 0 0 1 1 1h3.5a1 1 0 0 1 1 1v1zM4.118 4 4 4.059V13a1 1 0 0 0 1 1h6a1 1 0 0 0 1-1V4.059L11.882 4H4.118zM2.5 3V2h11v1h-11z"></path> </svg></button></td> </tr> <?php $i++; } ?> </table> <?php $sql2 = "select * from tb_criminal1 "; $query2 = mysqli_query($con, $sql2); $total_record = mysqli_num_rows($query2); $total_page = ceil($total_record / $perpage); ?> <!--Ligbox-- ถึงนี้นะ> <!-- The Modal --> <div class="modal" id="myModal" style="width: auto"> <div class="modal-dialog"> <div class="modal-content"> <!-- Modal Header --> <div class="modal-header"> <h4 class="modal-title">Modal Heading</h4> <button type="button" class="btn btn-dark" data-dismiss="modal">ปิด</button> </div> <!-- Modal body --> <div class="modal-body"> <table class="table " style="width=auto"> <tr> <th width="auto" style="background-color:blue"> <div align="left">ลำดับ </div></th> <th width="auto"> <div align="left">ชื่อ-นามสกุล (ผตห.) </div></th> <th width="auto"> <div align="left">เพศ </div></th> <th width="auto"> <div align="left">วัน/เดือน/ปีเกิด </div></th> <th width="auto"> <div align="left">รหัสบัตรประชาชน </div></th> <th width="auto"> <div align="left">ที่อยู่ </div></th> <th width="auto"> <div align="left">ประเภทการจับกุม </div></th> <th width="auto"> <div align="left">ข้อหากระทำความผิด </div></th> <th width="auto"> <div align="left">รูปจับกุม </div></th> <th width="auto"> <div align="left">วิดีโอ </div></th> <th width="auto"> <div align="left">เอกสาร </div></th> <th width="auto"> <div align="left">รายงาน </div></th> <th width="auto"> <div align="left">ดูข้อมูล </div></th> <th width="auto"> <div align="left">ลบข้อมูล </div></th> </table> </div> <!-- Modal footer --> <div class="modal-footer"> <button type="button" class="btn btn-danger" data-dismiss="modal">บันทึก</button> <button type="button" class="btn btn-danger" data-dismiss="modal">ยกเลิก</button> </div> </div> </div> </div> <!--Ligbox--> <style> .li-hover a:hover { background: #435ebe; //background instead of background-image } </style> <!--แสดงผลแบ่งหน้า--> <div class="from-control"><nav> <ul class="pagination justify-content-end"> <li class="page-item"> <a class="page-link" href="operation1-detail.php?page=1" aria-label="Previous"> ก่อนหน้า </a> </li> <?php for($i=1;$i<=$total_page;$i++){ ?> <li class="page-item li-hover"><a active class="page-link " href="operation1-detail.php?page=<?php echo $i; ?>"><?php echo $i; ?></a></li> <?php } ?> <li class="page-item"> <a class="page-link" href="operation1-detail.php?page=<?php echo $total_page;?>" aria-label="Next"> หน้าถัดไป </a> </li> </ul> </nav></div> </div> </div> </div> </div> </div> </div> </div> </div> <div class="row"> <div class="col-12 col-md-6"> <div class="card"> <div class="card-header"> <h4>ข้อมูลสถิติ</h4> </div> <div id="chart-profile-visit"></div> <div class="card-body"> <div class="row"> </div> </div> </div> </div> <div class="col-12 col-md-6"> <div class="card"> <div class="card-header"> <h4>ข้อมูลสถิติ</h4> </div> <div id="chart-visitors-profile"></div> <div class="card-body"> <div class="row"> </div> </div> </div> </div> </div> <!--clock--> <footer> <div class="footer clearfix mb-0 text-muted"> <div class="float-start"> <p >2021 © Division 1 Crime Suppression Division</p> </div> <div class="float-end"> <p>Crafted with <span class="text-danger"><i class="bi bi-heart"></i></span> by <a href="#">CSD-1 Admin</a></p> </div> </div> </footer> <script src="assets/vendors/perfect-scrollbar/perfect-scrollbar.min.js"></script> <script src="assets/js/bootstrap.bundle.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script> <script src="assets/vendors/apexcharts/apexcharts.js"></script> <script src="assets/js/pages/dashboard.js"></script> <script src="assets/js/main.js"></script> <?php mysqli_close($con); ?> </body> </html>
<!--แสดงผลแบ่งหน้า--> <div class="from-control"><nav> <ul class="pagination justify-content-end"> <li class="page-item"> <a class="page-link" href="operation1-detail.php?page=1" aria-label="Previous"> ก่อนหน้า </a> </li> <?php for($i=1;$i<=$total_page;$i++){ ?> <li class="page-item li-hover"><a active class="page-link " href="operation1-detail.php?page=<?php echo $i; ?>"><?php echo $i; ?></a></li> <?php } ?> <li class="page-item"> <a class="page-link" href="operation1-detail.php?page=<?php echo $total_page;?>" aria-label="Next"> หน้าถัดไป </a> </li> </ul> </nav></div>
<?php for($i=1;$i<=$total_page;$i++){ ?> <li class="page-item li-hover"> <?php if (isset($_GET['page']) && $_GET['page'] == $i) { ?><strong><?php } ?> <a active class="page-link " href="operation1-detail.php?page=<?php echo $i; ?>"><?php echo $i; ?></a> <?php if (isset($_GET['page']) && $_GET['page'] == $i) { ?></strong><?php } ?> </li> <?php } ?>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง
