card/make/channeloder.php

<?php
session_start();
if (isset($_SESSION["username"])) {
?>
  <?php require_once('common/header.php'); ?>
  <!--页面主要内容-->
  <main class="lyear-layout-content">
    <div class="container-fluid">
      <div class="row">
        <div class="col-lg-12">
          <div class="card">
            <div class="card-toolbar clearfix">
             
              <div class="toolbar-btn-action">
                <a class="btn btn-primary m-r-5" href="#"><i class="mdi mdi-plus"></i>导出订单</a>
                 <a class="btn btn-info m-r-5" href="#"><i class="mdi mdi-poll"></i>打印订单</a>
              </div>
              
            </div>
            <div class="card-body">
              <div class="table-responsive">
                <form name="form1" id="form1" method="post" action="controller/deleteall.php">
                  <table class="table table-bordered">
                    <?php
                    include_once("../untils/conn.php");
                    mysqli_query($con, "set names utf8");
                    if ($con) {
                      if ($db) {
                        //获取数据总行数
                        $channel_id = $_GET['channel_id'];
                        $sql = "select * from oder WHERE channel = '$channel_id'";
                        $data = mysqli_query($con, $sql);
                        $maxrows = mysqli_num_rows($data);
                        //计算总页数
                        $page_size = 10;  //每页显示数
                        if ($maxrows % $page_size == 0) {
                          $maxpage = (int)($maxrows / $page_size);
                        } else {
                          $maxpage = (int)($maxrows / $page_size) + 1;
                        }
                        //获取当前页
                        if (isset($_GET['curpage'])) {
                          $page = $_GET['curpage'];
                        } else {
                          $page = 1;
                        }
                        //分段取出数据
                        $start = $page_size * ($page - 1);
                        $get_sql = "select * from oder WHERE channel = '$channel_id' limit $start,$page_size";

                        //得到数据显示
                        $data = mysqli_query($con, $get_sql);
                        
                        // $timestamp= $row["time"];
                        // $time = date('Y-m-d H:i:s', $timestamp);
                        
                    ?>
                        <thead>
                          <tr>
                            <th>订单ID</th>
                            <th>商品名称</th>
                            <th>姓名</th>
                            <th>身份证号</th>
                            <th>手机号码</th>
                            <th>省份</th>
                            <th>城市</th>
                            <th>县区</th>
                            <th>详细地址</th>
                            <th>处理状态</th>
                            <th>备注</th>
                            <th>下单时间</th>
                            
                            <th>操作</th>
                          </tr>
                        </thead>
                        <tbody>
                          <?php
                          while ($row = mysqli_fetch_array($data)) {
                          ?>
                            <tr>
                              <td style="width:5%;">
                                <?php echo $row["id"] ?>
                              </td>
                              <td style="width:10%;"><?php echo $row["goods"] ?>
                              </td>
                              <td style="width:10%;"><?php echo $row["name"] ?>
                              </td>
                              <td style="width:10%;"><?php echo $row["uid"] ?>
                              </td>
                              <td style="width:10%;"><?php echo $row["phone"] ?>
                              </td>
                              <td style="width:10%;"><?php echo $row["sf"] ?>
                              </td>
                              <td style="width:10%;"><?php echo $row["city"] ?>
                              </td>
                              <td style="width:7.5%;"><?php echo $row["xian"] ?>
                              </td>
                              <td style="width:7.5%;"><?php echo $row["dizhi"] ?>
                              </td>
                             
                              <td style="width:7.5%;">
                                <?php 
                                    switch ($row["status"]) {
                                        case 0:
                                            echo "未处理";
                                            break;
                                        case 1:
                                            echo "已下单";
                                            break;
                                        case 2:
                                            echo "已发货";
                                            break;
                                        case 3:
                                            echo "开卡失败";
                                            break;
                                        default:
                                            echo "未知状态";
                                            break;
                                    } 
                                ?>
                            </td>


                              <td style="width:7.5%;"><?php echo $row["beizhu"] ?>
                              </td>
                               <td style="width:7.5%;">
                               <?php 
                               $timestamp= $row["time"] ;
                               $date = date('Y-m-d H:i:s', $timestamp);
                                echo $date; // 输出：2021-07-22 16:52:07
                               ?>
                              </td>
                               <td style="width:15%;">
                                <a href=updatesta.php?id=<?php echo $row['id'] ?> class="btn btn-danger btn-sm">处理</a>
                               
                                <a href="postapi.php?id=<?php echo $row['id'] ?>"  class="btn btn-success btn-sm">提审</a>
                              </td>
                              <!-- 上下架按钮 
                                <td>
                                  <div class="custom-control custom-switch">
                                    <input type="checkbox" class="custom-control-input" value="1">
                                    <label class="custom-control-label"></label>
                                  </div>
                                </td> -->
                            
                            </tr>
                          <?php
                          }
                          ?>
                        </tbody>
                        <tfoot>
                          <tr>
                            <td colspan="12" style="text-align: right;">
                          <?php
                          echo "<p>共 $maxpage 页&nbsp;&nbsp;";
                          echo "每页 $page_size 项&nbsp;&nbsp;";
                          //设置上一页
                          if ($page > 1) {
                            $prepage = $page - 1;
                            echo "<a href='?curpage=$prepage'>上一页</a>&nbsp;&nbsp;";
                          }
                          //设置下一页
                          if ($page < $maxpage) {
                            $nextpage = $page + 1;
                            echo "<a href='?curpage=$nextpage'>下一页</a>&nbsp;&nbsp;";
                          }
                          echo "&nbsp;&nbsp;第 $page 页</p>";
                        }
                      }
                          ?>
                            </td>
                          </tr>
                        </tfoot>
                  </table>
                </form>
              </div>
            </div>
          </div>
        </div>
      </div>
    </div>
    </div>
    <script>
        $(document).ready(function(){
            $('.update-btn').click(function(e){
                e.preventDefault();
                var id = $(this).data('id');
                $.ajax({
                    url: 'updatesta.php',
                    type: 'GET',
                    data: {id: id},
                    success: function(data){
                        alert('状态处理成功！');
                    },
                    error: function(jqXHR, textStatus, errorThrown){
                        console.log(textStatus);
                    }
                });
            });
        });
</script>
  </main>
  <!--End 页面主要内容-->
  <?php require_once('common/footer.php'); ?>
<?php
} else {
  echo "<script>alert('您尚未登录，没有权限访问该页面');location.href='login.php';</script>";
}