iComsium
/home/u575951074/domains/bookedgebookkeeping.com/public_html/admin/show-job.php - Dosyasını Düzenle
<?php include("include/config.php"); include("include/checklog.php"); ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>Royal Trucks</title> <!-- Tell the browser to be responsive to screen width --> <meta name="viewport" content="width=device-width, initial-scale=1"> <!-- Font Awesome --> <link rel="stylesheet" href="plugins/fontawesome-free/css/all.min.css"> <!-- Ionicons --> <link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css"> <!-- Tempusdominus Bbootstrap 4 --> <link rel="stylesheet" href="plugins/tempusdominus-bootstrap-4/css/tempusdominus-bootstrap-4.min.css"> <!-- iCheck --> <link rel="stylesheet" href="plugins/icheck-bootstrap/icheck-bootstrap.min.css"> <!-- JQVMap --> <link rel="stylesheet" href="plugins/jqvmap/jqvmap.min.css"> <!-- Theme style --> <link rel="stylesheet" href="dist/css/adminlte.min.css"> <!-- overlayScrollbars --> <link rel="stylesheet" href="plugins/overlayScrollbars/css/OverlayScrollbars.min.css"> <!-- Daterange picker --> <link rel="stylesheet" href="plugins/daterangepicker/daterangepicker.css"> <!-- summernote --> <link rel="stylesheet" href="plugins/summernote/summernote-bs4.css"> <!-- Google Font: Source Sans Pro --> <link href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700" rel="stylesheet"> </head> <body class="hold-transition sidebar-mini layout-fixed"> <div class="wrapper"> <!-- Navbar --> <nav class="main-header navbar navbar-expand navbar-white navbar-light"> <!-- Left navbar links --> <ul class="navbar-nav"> <li class="nav-item"> <a class="nav-link" data-widget="pushmenu" href="#" role="button"><i class="fas fa-bars"></i></a> </li> <!--<li class="nav-item d-none d-sm-inline-block"> <a href="index3.html" class="nav-link">Home</a> </li> <li class="nav-item d-none d-sm-inline-block"> <a href="#" class="nav-link">Contact</a> </li>--> </ul> <!-- SEARCH FORM --> <!--<form class="form-inline ml-3"> <div class="input-group input-group-sm"> <input class="form-control form-control-navbar" type="search" placeholder="Search" aria-label="Search"> <div class="input-group-append"> <button class="btn btn-navbar" type="submit"> <i class="fas fa-search"></i> </button> </div> </div> </form>--> <!-- Right navbar links --> </nav> <!-- /.navbar --> <!-- Main Sidebar Container --> <?php include("include/sidebar.php"); ?> <!-- Content Wrapper. Contains page content --> <div class="content-wrapper"> <!-- Content Header (Page header) --> <div class="content-header"> <div class="container-fluid"> <div class="row mb-2"> <div class="col-sm-6"> <h1 class="m-0 text-dark">All Job </h1> </div><!-- /.col --> <div class="col-sm-6"> <ol class="breadcrumb float-sm-right"> <li class="breadcrumb-item"><a href="#">Home</a></li> <li class="breadcrumb-item active"><a href="logout.php">Logout</a></li> </ol> </div><!-- /.col --> </div><!-- /.row --> </div><!-- /.container-fluid --> </div> <!-- /.content-header --> <!-- Main content --> <section class="content"> <div class="container-fluid"> <!-- Small boxes (Stat box) --> <!-- /.row --> <!-- Main row --> <div class="row"> <div class="col-12"> <div class="card"> <div class="card-header"> <h3 class="card-title">Job Lising</h3> <div class="card-tools"> <div class="input-group input-group-sm" style="width: 150px;"> <input type="text" name="table_search" class="form-control float-right" placeholder="Search"> <div class="input-group-append"> <button type="submit" class="btn btn-default"><i class="fas fa-search"></i></button> </div> </div> </div> </div> <!-- /.card-header --> <div class="card-body table-responsive p-0"> <table class="table table-hover text-nowrap"> <thead> <tr> <th>Customer Name</th> <th>Vehicle Type</th> <th>Delivery Location</th> <th>Container No</th> <th>Delivery Date</th> <th>Driver Name</th> <th>Edit</th> <th>Delete</th> </tr> </thead> <tbody> <?php $sql="select *from job order by id desc "; $result=mysqli_query($conn,$sql); while($row=mysqli_fetch_assoc($result)) { $sql3="select *from vehicle_type where id='".$row["vehicle_type"]."' "; $result3=mysqli_query($conn,$sql3); $row3=mysqli_fetch_assoc($result3); $sql4="select *from driver where id='".$row["driver_name"]."' "; $result4=mysqli_query($conn,$sql4); $row4=mysqli_fetch_assoc($result4); $sql5="select *from customer where id='".$row["customer_name"]."' "; $result5=mysqli_query($conn,$sql5); $row5=mysqli_fetch_assoc($result5); ?> <tr> <td><?php echo $row5["customer_name"]; ?></td> <td><?php echo $row3["type_name"]; ?></td> <td><?php echo $row["delivery_location"]; ?></td> <td><?php echo $row["container_no"]; ?></td> <td><?php echo $row["delivery_date"]; ?></td> <td><?php echo $row4["driver_name"]; ?></td> <td><button type="button" class="btn btn-primary" onclick="window.location.href='edit-job.php?id=<?php echo base64_encode($row["id"]); ?>'" >Edit</button></td> <td><button type="button" class="btn btn-primary" onclick="window.location.href='delete-job.php?id=<?php echo base64_encode($row["id"]); ?>'" >Delete</button></td> </tr> <?php } ?> </tbody> </table> </div> <!-- /.card-body --> </div> <!-- /.card --> </div> </div> <!-- /.row (main row) --> </div><!-- /.container-fluid --> </section> <!-- /.content --> </div> <!-- /.content-wrapper --> <footer class="main-footer"> <strong>Copyright © 2020 Royal Truck.</strong> All rights reserved. <div class="float-right d-none d-sm-inline-block"> </div> </footer> <!-- Control Sidebar --> <aside class="control-sidebar control-sidebar-dark"> <!-- Control sidebar content goes here --> </aside> <!-- /.control-sidebar --> </div> <!-- ./wrapper --> <!-- jQuery --> <script src="plugins/jquery/jquery.min.js"></script> <!-- jQuery UI 1.11.4 --> <script src="plugins/jquery-ui/jquery-ui.min.js"></script> <!-- Resolve conflict in jQuery UI tooltip with Bootstrap tooltip --> <script> $.widget.bridge('uibutton', $.ui.button) </script> <!-- Bootstrap 4 --> <script src="plugins/bootstrap/js/bootstrap.bundle.min.js"></script> <!-- ChartJS --> <script src="plugins/chart.js/Chart.min.js"></script> <!-- Sparkline --> <script src="plugins/sparklines/sparkline.js"></script> <!-- JQVMap --> <script src="plugins/jqvmap/jquery.vmap.min.js"></script> <script src="plugins/jqvmap/maps/jquery.vmap.usa.js"></script> <!-- jQuery Knob Chart --> <script src="plugins/jquery-knob/jquery.knob.min.js"></script> <!-- daterangepicker --> <script src="plugins/moment/moment.min.js"></script> <script src="plugins/daterangepicker/daterangepicker.js"></script> <!-- Tempusdominus Bootstrap 4 --> <script src="plugins/tempusdominus-bootstrap-4/js/tempusdominus-bootstrap-4.min.js"></script> <!-- Summernote --> <script src="plugins/summernote/summernote-bs4.min.js"></script> <!-- overlayScrollbars --> <script src="plugins/overlayScrollbars/js/jquery.overlayScrollbars.min.js"></script> <!-- AdminLTE App --> <script src="dist/js/adminlte.js"></script> <!-- AdminLTE dashboard demo (This is only for demo purposes) --> <script src="dist/js/pages/dashboard.js"></script> <!-- AdminLTE for demo purposes --> <script src="dist/js/demo.js"></script> </body> </html>
Geri Dön