master

分支 (1)

管理

管理

master

Company-directory
/
person_list - 纯过程化.php

<?php
include_once("./config/init.php");

//定义分页参数  如果有传递分页就获取  如果没有 那么默认就第一页  当前页码
//page 自定义
$page = isset($_GET['page']) ? $_GET['page'] : 1;

//每页显示多少条 limit自定义
$limit = 5;

//算出总条数  要查询语句确定有多少条
$sql = "SELECT COUNT(id) AS c FROM {$pre_}person";
$count = getOne($sql);

// var_dump($count);
// exit;

$count = $count['c'];
// var_dump($count);
// exit;

//算出总共有多少页
$pages = ceil($count/$limit);

// var_dump($pages);
// exit;

//组装分页字符串   拼接
$str = "";

$str .= "<ul>";

//首页 上一页
if($page <= 1){
    $str .="<li><a href='javascript:void(0)'>首页</a></li>";
    $str .="<li><a href='javascript:void(0)'>上一页</a></li>";
}else{
    //为什么要传递page参数 因为  上面有获取  不传那么我始终都是第一页
    $str .="<li><a href='?page=1'>首页</a></li>";
    $current = $page-1;//上一页的页码值
    $str .="<li><a href='?page=$current'>上一页</a></li>";
}


for($i=1;$i<=$pages;$i++)
{
    if($i == $page)
    {
        //当前的页码是不能点击的
        $str .="<li><a href='javascript:void(0)'>$i</a></li>";
    }else{
        $str .="<li><a href='?page=$i'>$i</a></li>";
    }
}


//尾页 下一页  尾部  尾页 == 总页数 $page  当前页 $pages 总页数
if($page >= $pages)
{
    $str .="<li><a href='javascript:void(0)'>下一页</a></li>";
    $str .="<li><a href='javascript:void(0)'>尾页</a></li>";
}else{
    //没有到达最后一页
    $current = $page+1;
    $str .="<li><a href='?page=$current'>下一页</a></li>";
    $str .="<li><a href='?page=$pages'>尾页</a></li>";
}


$str .="</ul>";

// echo $str;
// exit;

//偏移量
$start = ($page-1)*$limit;

//获取员工列表
$sql = "SELECT * FROM {$pre_}person LIMIT $start,$limit";

//链表查询 查询员工的所有数据
$sql = "SELECT person.*,dep.name AS depName,job.name AS jobName FROM {$pre_}person AS person LEFT JOIN {$pre_}department AS dep ON person.depid = dep.id LEFT JOIN {$pre_}job AS job ON person.jobid = job.id LIMIT $start,$limit";
$personlist = getAll($sql);


// var_dump($personlist);
// exit;
?>

<!DOCTYPE html>
<html lang="en">
  <head>
  <?php include_once('meta.php');  ?>
  </head>


  <body>
  <!--<![endif]-->


    <!-- 头部 -->
    <?php include_once('header.php');  ?>

    <!-- 菜单 -->
    <?php include_once('menu.php');  ?>


    <div class="content">
        <div class="header">
            <h1 class="page-title">员工列表</h1>
        </div>
        <ul class="breadcrumb">
            <li><a href="index.php">首页</a> <span class="divider">/</span></li>
            <li class="active">Index</li>
        </ul>

        <div class="container-fluid">
            <div class="row-fluid">
                <div class="btn-toolbar">
                    <button class="btn btn-primary" onClick="location='person_add.php'"><i class="icon-plus"></i>添加员工</button>
                </div>
                <div class="well">
                    <table class="table">
                      <thead>
                        <tr>
                          <th><input type="checkbox" name="check" id="check"></th>
                          <th>姓名</th>
                          <th>手机号码</th>
                          <th>性别</th>
                          <th>所属部门</th>
                          <th>所属职位</th>
                          <th>入职时间</th>
                          <th style="width: 50px;"></th>
                        </tr>
                      </thead>
                      <tbody>
                        <?php foreach($personlist as $item){?>
                        <tr>
                          <td>
                              <!-- 这样写 personid[] 当我们传递数据给php的时候 得到的会是一个数组 -->
                              <input type="checkbox" name="check" value="<?php echo $item['id'];?>">
                            </td>
                          <td><?php echo $item['id']."----". $item['name'];?></td>
                          <td><?php echo $item['phone'];?></td>
                          <td><?php echo $item['sex'] ? "男":"女";?></td>
                          <td><?php echo $item['depName'];?></td>
                          <td><?php echo $item['jobName'];?></td>
                          <td><?php echo date("Y-m-d",$item['createtime']);?></td>
                          <td>
                              <a href="person_edit.php?personid=<?php echo $item['id'];?>"><i class="icon-pencil"></i></a>
                              <a href="#myModal" role="button" data-toggle="modal"><i class="icon-remove"></i></a>
                          </td>

                        </tr>
                        <?php }?>

                        <tr>
                            <td colspan="7">
                              <button>批量删除</button>
                             </td>

                         </tr>


                      </tbody>
                    </table>
                </div>
                <div class="pagination">
                 <!-- 输出分页 拼接的字符串 -->
                 <?php echo $str;?>
                </div>

                <div class="modal small hide fade" id="myModal" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
                    <div class="modal-header">
                        <button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
                        <h3 id="myModalLabel">Delete Confirmation</h3>
                    </div>
                    <div class="modal-body">
                        <p class="error-text"><i class="icon-warning-sign modal-icon"></i>Are you sure you want to delete the user?</p>
                    </div>
                    <div class="modal-footer">
                        <button class="btn" data-dismiss="modal" aria-hidden="true">Cancel</button>
                        <button class="btn btn-danger" data-dismiss="modal">Delete</button>
                    </div>
                </div>

                <footer>
                    <hr>
                    <p>&copy; 2017 <a href="#" target="_blank">copyright</a></p>
                </footer>
            </div>
        </div>
    </div>


  </body>
</html>
    <!-- 底部 -->
    <?php include_once('footer.php');  ?>