Community Learn Tools Library Leisure
search
English
Home > List of blog posts > CMS后台管理商城系统（三） 商品分类管理 商品管理 用户列表 订单列表
Blogger Information
Blog 42
fans 2
comment 0
visits 53934
Special Recommendation
More>
Related recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
CMS后台管理商城系统（三） 商品分类管理 商品管理 用户列表 订单列表
小明的博客
Original
3112 people have browsed it

今天完成了商品分类管理、商品管理、用户管理、订单列表功能

一、商品分类管理
商品分类主要功能是新建商品一级分类列表，有添加、编辑、删除功能，还有二级分类列表。添加编辑，更具传入的id值确定，然后将id传给add方法，然后查到数据，展示给前台，然后保存；删除根据传入的id来删除；二级列表通过url方法，将传入的id值get到二级分类列表方法，然后查询该id下的所有记录。
  1. //分类一级
  2.     public function cat_index() {
  3.         $list = $this->db->table('shop_cat')->where(array('cat_fid'=>0))->order('sort DESC')->lists();
  4.         $this->assign('list', $list);
  5.         return $this->fetch();
  6.     }
  7.     //添加编辑商品分类
  8.     public function cat_add() {
  9.         $id = (int)input('get.id');
  10.         $fid = (int)input('get.fid');
  12.         //查询出id的商品分类记录
  13.         $data = $this->db->table('shop_cat')->where(array('cat_id'=>$id))->item();
  14.         $this->assign('data', $data);
  15.         $this->assign('fid', $fid);
  16.         return $this->fetch();
  17.     }
  18.     //保存商品分类
  19.     public function cat_save() {
  20.         //将传过来的数据整理在一起
  21.         $id = (int)input('post.cat_id');
  22.         $data['cat_name'] = trim(input('post.cat_name'));
  23.         $data['sort'] = (int)input('post.sort');
  24.         $data['status'] = (int)input('post.status');
  25.         //判断 如果id存在那么就是修改执行更新操作
  26.         if ($id) {
  27.             $res = $this->db->table('shop_cat')->where(array('cat_id'=>$id))->update($data);
  28.         } else {
  29.             //如果id不存在 那么就是新增需要把level fid 和data插入
  30.             $data['cat_fid'] = (int)input('post.fid');
  31.             $res = $this->db->table('shop_cat')->insert($data);
  32.         }
  33.         if ($res) {
  34.             exit(json_encode(array('code'=>0, 'msg'=>'保存成功')));
  35.         } else {
  36.             exit(json_encode(array('code'=>1, 'msg'=>'保存失败')));
  37.         }
  38.     }
  39.     //删除分类
  40.     public function cat_del() {
  41.         $id = (int)input('post.id');
  42.         //16 执行删除操作
  43.         $res = $this->db->table('shop_cat')->where(array('cat_id'=>$id))->delete();
  44.         if (!$res) {
  45.             exit(json_encode(array('code'=>1, 'msg'=>'删除失败')));
  46.         }
  47.         exit(json_encode(array('code'=>0, 'msg'=>'删除成功')));
  48.     }
  49.     //二级分类列表
  50.     public function cat_two_index() {
  51.         $fid = (int)input('get.fid');
  52.         //查找出一级分类记录
  53.         $item = $this->db->table('shop_cat')->where(array('cat_id'=>$fid))->item();
  54.         $list = $this->db->table('shop_cat')->where(array('cat_fid'=>$fid))->lists();
  55.         $this->assign('list', $list);
  56.         $this->assign('item', $item);
  57.         $this->assign('fid', $fid);
  58.         return $this->fetch();
  59.     }
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4.     <title></title>
  5.     <link rel="stylesheet" type="text/css" href="/static/plugins/layui/css/layui.css">
  6.     <script type="text/javascript" src="/static/plugins/layui/layui.js"></script>
  7.     <style type="text/css">
  8.         .header span{background: #009688;margin-left: 30px;padding: 10px;color:#ffffff;}
  9.         .header div{border-bottom: solid 2px #009688;margin-top: 8px;}
  10.         .header button{float: right;margin-top: -5px;}
  11.     </style>
  12. </head>
  13. <body style="padding: 10px;">
  14. <div class="header">
  15.     <span>商品一级分类</span>
  16.     <button class="layui-btn layui-btn-sm" onclick="add()">添加</button>
  17.     <div></div>
  18. </div>
  20. <table class="layui-table">
  21.     <thead>
  22.     <tr>
  23.         <th>排序</th>
  24.         <th>ID</th>
  25.         <th>分类名</th>
  26.         <th>状态</th>
  27.         <th>二级列表</th>
  28.         <th>操作</th>
  29.     </tr>
  30.     </thead>
  31.     <tbody>
  32.     <!-- 循环出所有广告分类       -->
  33.     {volist name="list" id="vo"}
  34.     <tr>
  35.         <td>{$vo.sort}</td>
  36.         <td>{$vo.cat_id}</td>
  37.         <td>{$vo.cat_name}</td>
  38.         <td>{if condition="$vo.status == 1"}<span style="color: green;">开启</span>{else/}<span style="color: red;">关闭</span>{/if}</td>
  39.         <td>
  40.             <button class="layui-btn layui-btn-xs" onclick="url({$vo.cat_id})">进入二级分类列表</button>
  41.         </td>
  42.         <td>
  43.             <button class="layui-btn layui-btn-xs" onclick="add({$vo.cat_id})">编辑</button>
  44.             <button class="layui-btn layui-btn-danger layui-btn-xs" onclick="del({$vo.cat_id})">删除</button>
  45.         </td>
  46.     </tr>
  47.     {/volist}
  48.     </tbody>
  49. </table>
  51. <script type="text/javascript">
  52.     layui.use(['layer'],function(){
  53.         layer = layui.layer;
  54.         $ = layui.jquery;
  55.     });
  57.     // 添加编辑
  58.     function add(id) {
  59.         layer.open({
  60.             type: 2,
  61.             title: id>0 ? '编辑分类' : '添加分类',
  62.             shade: 0.3,
  63.             area: ['480px', '420px'],
  64.             content: '/index.php/admins/Shop/cat_add?id='+id
  65.         });
  66.     }
  67.     //分类下的广告列表
  68.     function url(id) {
  69.         window.location.href = "/index.php/admins/Shop/cat_two_index?fid="+id;
  70.     }
  72.     // 删除
  73.     function del(id) {
  74.         layer.confirm('确定要删除吗？', {
  75.             icon: 3,
  76.             btn: ['确定', '取消']
  77.         }, function () {
  78.             $.post('/index.php/admins/Shop/cat_del', {'id':id}, function (res) {
  79.                 if (res.code > 0) {
  80.                     layer.alert(res.msg, {icon:2});
  81.                 } else {
  82.                     layer.msg(res.msg);
  83.                     setTimeout(function () {
  84.                         window.location.reload();
  85.                     }, 1000)
  86.                 }
  87.             }, 'json');
  88.         });
  89.     }
  90. </script>
  91. </body>
  92. </html>
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4.     <title></title>
  5.     <link rel="stylesheet" type="text/css" href="/static/plugins/layui/css/layui.css">
  6.     <script type="text/javascript" src="/static/plugins/layui/layui.js"></script>
  7. </head>
  8. <body style="padding: 10px;">
  9. <form class="layui-form">
  10.     <!-- hidden 是把input框隐藏，它的作用是把一些隐藏信息传值到接口中 -->
  11.     <input type="hidden" name="cat_id" value="{$data.cat_id}">
  12.     <input type="hidden" name="fid" value="{$fid}">
  13.     <div class="layui-form-item">
  14.         <label class="layui-form-label">名称</label>
  15.         <div class="layui-input-inline">
  16.             <input type="text" class="layui-input" name="cat_name" value="{$data.cat_name}">
  17.         </div>
  18.     </div>
  20.     <div class="layui-form-item">
  21.         <label class="layui-form-label">排序</label>
  22.         <div class="layui-input-inline">
  23.             <input type="text" class="layui-input" name="sort" value="{$data.sort}">
  24.         </div>
  25.     </div>
  26.     <div class="layui-form-item">
  27.         <label class="layui-form-label">状态</label>
  28.         <div class="layui-input-inline">
  29.             <input type="checkbox" name="status" lay-skin="primary" title="开启" value="1" {$data.status==1 || !$data ?'checked':''}>
  30.         </div>
  31.     </div>
  32. </form>
  33. <div class="layui-form-item">
  34.     <div class="layui-input-block">
  35.         <button class="layui-btn" onclick="save()">保存</button>
  36.     </div>
  37. </div>
  39. <script type="text/javascript">
  40.     layui.use(['layer','form'],function(){
  41.         form = layui.form;
  42.         layer = layui.layer;
  43.         $ = layui.jquery;
  44.     });
  46.     // 保存管理员
  47.     function save(){
  48.         // 用js 获取省名称 首字母
  49.         var cat_name = $.trim($('input[name="cat_name"]').val());
  50.         if(cat_name==''){
  51.             layer.alert('请输入名称',{icon:2});
  52.             return;
  53.         }
  54.         // 请求保存接口，把数据传值到接口中。
  55.         $.post('/index.php/admins/Shop/cat_save',$('form').serialize(),function(res){
  56.             if(res.code>0){
  57.                 layer.alert(res.msg,{icon:2});
  58.             }else{
  59.                 layer.msg(res.msg);
  60.                 setTimeout(function(){parent.window.location.reload();},1000);
  61.             }
  62.         },'json');
  63.     }
  65. </script>
  66. </body>
  67. </html>
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4.     <title></title>
  5.     <link rel="stylesheet" type="text/css" href="/static/plugins/layui/css/layui.css">
  6.     <script type="text/javascript" src="/static/plugins/layui/layui.js"></script>
  7.     <style type="text/css">
  8.         .header span{background: #009688;margin-left: 30px;padding: 10px;color:#ffffff;}
  9.         .header div{border-bottom: solid 2px #009688;margin-top: 8px;}
  10.         .header button{float: right;margin-top: -5px;}
  11.     </style>
  12. </head>
  13. <body style="padding: 10px;">
  14. <div class="header">
  15.     <span style="background-color:#999;"><a href="/index.php/admins/Shop/cat_index" style="color:#fff;">商品分类一级列表</a></span>
  16.     <span>{$item.cat_name}的二级列表</span>
  17.     <button class="layui-btn layui-btn-sm" onclick="add()">添加</button>
  18.     <div></div>
  19. </div>
  21. <table class="layui-table">
  22.     <thead>
  23.     <tr>
  24.         <th>排序</th>
  25.         <th>ID</th>
  26.         <th>分类名</th>
  27.         <th>状态</th>
  28.         <th>操作</th>
  29.     </tr>
  30.     </thead>
  31.     <tbody>
  32.     <!-- 循环出二级分类       -->
  33.     {volist name="list" id="vo"}
  34.     <tr>
  35.         <td>{$vo.sort}</td>
  36.         <td>{$vo.cat_id}</td>
  37.         <td>{$vo.cat_name}</td>
  38.         <td>{if condition="$vo.status == 1"}<span style="color: green;">开启</span>{else/}<span style="color: red;">关闭</span>{/if}</td>
  39.         <td>
  40.             <button class="layui-btn layui-btn-xs" onclick="add({$vo.cat_id})">编辑</button>
  41.             <button class="layui-btn layui-btn-danger layui-btn-xs" onclick="del({$vo.cat_id})">删除</button>
  42.         </td>
  43.     </tr>
  44.     {/volist}
  45.     </tbody>
  46. </table>
  48. <script type="text/javascript">
  49.     layui.use(['layer'],function(){
  50.         layer = layui.layer;
  51.         $ = layui.jquery;
  52.     });
  53.     var fid = '{$fid}';
  54.     // 添加编辑
  55.     function add(id) {
  56.         layer.open({
  57.             type: 2,
  58.             title: id>0 ? '编辑分类' : '添加分类',
  59.             shade: 0.3,
  60.             area: ['480px', '420px'],
  61.             content: '/index.php/admins/Shop/cat_add?id='+id+'&fid='+fid
  62.         });
  63.     }
  65.     // 删除
  66.     function del(id) {
  67.         layer.confirm('确定要删除吗？', {
  68.             icon: 3,
  69.             btn: ['确定', '取消']
  70.         }, function () {
  71.             $.post('/index.php/admins/Shop/cat_del', {'id':id}, function (res) {
  72.                 if (res.code > 0) {
  73.                     layer.alert(res.msg, {icon:2});
  74.                 } else {
  75.                     layer.msg(res.msg);
  76.                     setTimeout(function () {
  77.                         window.location.reload();
  78.                     }, 1000)
  79.                 }
  80.             }, 'json');
  81.         });
  82.     }
  83. </script>
  84. </body>
  85. </html>
二、商品管理

道理和之前的一样，查询所有商品在前端展示出来，可以添加编辑删除，重点在添加编辑功能，有图片上传功能和一二级分类选择（下一节在完善）。

  1. //商品列表
  2.     public function shop_index() {
  3.         //查询出商品列表中的所有商品
  4.         $list = $this->db->table('shop_goods')->order('sort DESC,id DESC')->lists();
  5.         //查找出该商品的分类，将分类名赋给list
  6.         if ($list) {
  7.             foreach ($list as &$v) {
  8.                 $cat = $this->db->table('shop_cat')->where(array('cat_id'=>$v['cat_id']))->item();
  9.                 $v['cat_name'] = $cat['cat_name'];
  10.             }
  11.         }
  12.         $this->assign('list', $list);
  13.         return $this->fetch();
  14.     }
  15.     //添加编辑商品
  16.     public function shop_add() {
  17.         $id = (int)input('get.id');
  18.         //查找出id对应下的单条商品记录
  19.         $data = $this->db->table('shop_goods')->where(array('id'=>$id))->item();
  20.         $this->assign('data', $data);
  21.         //  查询出所有的一级分类
  22.         $cat = $this->db->table('shop_cat')->where(array('status'=>1, 'cat_fid'=>0))->lists();
  23.         $this->assign('cat', $cat);
  24.         return $this->fetch();
  25.     }
  26.     //保存商品信息
  27.     public function shop_save(){
  28.         $id = (int)input('post.id');
  29.         $data['cat_id'] = (int)input('post.cat_id');        // 分类ID
  30.         $data['title'] = trim(input('post.title'));            // 标题
  31.         $data['price'] = trim(input('post.price'));            // 价格
  32.         $data['o_price'] = trim(input('post.o_price'));        // 原价
  33.         $data['img'] = input('post.img');                    // 图片
  34.         $data['info'] = trim(input('post.info'));            // 商品介绍
  35.         $data['sort'] = (int)input('post.sort');            // 排序
  36.         $data['status'] = (int)input('post.status');        // 状态
  37.         if($id){
  38.             $add = $this->db->table('shop_goods')->where(array('id'=>$id))->update($data);
  39.         }else{
  40.             $add = $this->db->table('shop_goods')->insert($data);
  41.         }
  42.         if($add > 0){
  43.             exit(json_encode(array('code'=>0,'msg'=>'数据保存成功')));
  44.         }else{
  45.             exit(json_encode(array('code'=>1,'msg'=>'数据保存失败')));
  46.         }
  47.     }
  48.     # 商品删除
  49.     public function shop_del(){
  50.         $id = (int)input('post.id');
  51.         $del = $this->db->table('shop_goods')->where(array('id'=>$id))->delete();
  52.         if($del){
  53.             exit(json_encode(array('code'=>0,'msg'=>'删除成功')));
  54.         }else{
  55.             exit(json_encode(array('code'=>1,'msg'=>'删除失败')));
  56.         }
  57.     }
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4.     <title></title>
  5.     <link rel="stylesheet" type="text/css" href="/static/plugins/layui/css/layui.css">
  6.     <script type="text/javascript" src="/static/plugins/layui/layui.js"></script>
  7.     <style type="text/css">
  8.         .header span{background: #009688;margin-left: 30px;padding: 10px;color:#ffffff;}
  9.         .header div{border-bottom: solid 2px #009688;margin-top: 8px;}
  10.         .header button{float: right;margin-top: -5px;}
  11.     </style>
  12. </head>
  13. <body style="padding: 10px;">
  14. <div class="header">
  15.     <span>商品列表</span>
  16.     <button class="layui-btn layui-btn-sm" onclick="add()">添加</button>
  17.     <div></div>
  18. </div>
  20. <table class="layui-table">
  21.     <thead>
  22.     <tr>
  23.         <th>排序</th>
  24.         <th>ID</th>
  25.         <th>分类</th>
  26.         <th>标题</th>
  27.         <th>价格</th>
  28.         <th>原价</th>
  29.         <th>图片</th>
  30.         <th>状态</th>
  31.         <th>操作</th>
  32.     </tr>
  33.     </thead>
  34.     <tbody>
  35.     <!-- 循环出所有商品      -->
  36.     {volist name="list" id="vo"}
  37.     <tr>
  38.         <td>{$vo.sort}</td>
  39.         <td>{$vo.id}</td>
  40.         <td>{$vo.cat_id}</td>
  41.         <td>{$vo.title}</td>
  42.         <td>{$vo.price}</td>
  43.         <td>{$vo.o_price}</td>
  44.         <td><img src="{$vo.img}" alt=""></td>
  45.         <td>{if condition="$vo.status == 1"}<span style="color: green;">开启</span>{else/}<span style="color: red;">关闭</span>{/if}</td>
  46.         <td>
  47.             <button class="layui-btn layui-btn-xs" onclick="add({$vo.id})">编辑</button>
  48.             <button class="layui-btn layui-btn-danger layui-btn-xs" onclick="del({$vo.id})">删除</button>
  49.         </td>
  50.     </tr>
  51.     {/volist}
  52.     </tbody>
  53. </table>
  55. <script type="text/javascript">
  56.     layui.use(['layer'],function(){
  57.         layer = layui.layer;
  58.         $ = layui.jquery;
  59.     });
  61.     // 添加编辑
  62.     function add(id) {
  63.         layer.open({
  64.             type: 2,
  65.             title: id>0 ? '编辑分类' : '添加分类',
  66.             shade: 0.3,
  67.             area: ['1080px', '600px'],
  68.             content: '/index.php/admins/Shop/shop_add?id='+id
  69.         });
  70.     }
  71.     // 删除
  72.     function del(id) {
  73.         layer.confirm('确定要删除吗？', {
  74.             icon: 3,
  75.             btn: ['确定', '取消']
  76.         }, function () {
  77.             $.post('/index.php/admins/Shop/shop_del', {'id':id}, function (res) {
  78.                 if (res.code > 0) {
  79.                     layer.alert(res.msg, {icon:2});
  80.                 } else {
  81.                     layer.msg(res.msg);
  82.                     setTimeout(function () {
  83.                         window.location.reload();
  84.                     }, 1000)
  85.                 }
  86.             }, 'json');
  87.         });
  88.     }
  89. </script>
  90. </body>
  91. </html>
  1. <!DOCTYPE html>
  2. <html xmlns="http://www.w3.org/1999/html">
  3. <head>
  4.     <title></title>
  5.     <link rel="stylesheet" type="text/css" href="/static/plugins/layui/css/layui.css">
  6.     <script type="text/javascript" src="/static/plugins/layui/layui.js"></script>
  7. </head>
  8. <body style="padding: 10px;">
  9. <form class="layui-form">
  10.     <!-- hidden 是把input框隐藏，它的作用是把一些隐藏信息传值到接口中 -->
  11.     <input type="hidden" name="id" value="{$data.id}">
  12.     <div class="layui-form-item">
  13.         <label class="layui-form-label">标题</label>
  14.         <div class="layui-input-inline">
  15.             <input type="text" class="layui-input" name="title" value="{$data.title}">
  16.         </div>
  17.     </div>
  18.     <div class="layui-form-item">
  19.         <label class="layui-form-label">一级分类</label>
  20.         <div class="layui-input-inline">
  21.             <select name="cat_fid" id="cat_id">
  22.                 <option value="0">请选择</option>
  23.                 {volist name="cat" id="cat_vo"}
  24.                 <option value="{$cat_vo['cat_id']}">{$cat_vo.cat_name}</option>
  25.                 {/volist}
  26.             </select>
  27.         </div>
  28.     </div>
  29.     <div class="layui-form-item">
  30.         <label class="layui-form-label">二级分类</label>
  31.         <div class="layui-input-inline">
  32.             <select name="cat_id">
  33.                 <option value=0>请选择</option>
  35.             </select>
  36.         </div>
  37.     </div>
  38.     <div class="layui-form-item">
  39.         <label class="layui-form-label">原价</label>
  40.         <div class="layui-input-inline">
  41.             <input type="text" class="layui-input" name="price" value="{$data.price}">
  42.         </div>
  43.     </div>
  44.     <div class="layui-form-item">
  45.         <label class="layui-form-label">现价</label>
  46.         <div class="layui-input-inline">
  47.             <input type="text" class="layui-input" name="o_price" value="{$data.o_price}">
  48.         </div>
  49.     </div>
  50.     <div class="layui-form-item">
  51.         <label class="layui-form-label">图片上传</label>
  52.         <div class="layui-upload">
  53.             <button type="button" class="layui-btn" id="test1">上传图片</button>
  54.         </div>
  55.     </div>
  56.     <div class="layui-form-item">
  57.         <label class="layui-form-label">图片预览</label>
  58.         <div class="layui-upload-list">
  59.             <img class="layui-upload-img" id="demo1" style="width: 200px;" src="{$data.img}">
  60.             <p id="demoText"></p>
  61.             <input type="hidden" name="img" value="">
  62.         </div>
  63.     </div>
  64.     <div class="layui-form-item">
  65.         <label class="layui-form-label">排序</label>
  66.         <div class="layui-input-inline">
  67.             <input type="text" class="layui-input" name="sort" value="{$data.sort}">
  68.         </div>
  69.     </div>
  70.     <div class="layui-form-item">
  71.         <label class="layui-form-label">状态</label>
  72.         <div class="layui-input-inline">
  73.             <input type="checkbox" name="status" lay-skin="primary" title="开启" value="1" {$data.status==1 || !$data ?'checked':''}>
  74.         </div>
  75.     </div>
  76.     <div class="layui-form-item">
  77.         <label class="layui-form-label">商品介绍</label>
  78.         <div class="layui-input-inline" id="editor" style="width: 80%;">
  80.         </div>
  81.     </div>
  82. </form>
  83. <div class="layui-form-item">
  84.     <div class="layui-input-block">
  85.         <button class="layui-btn" onclick="save()">保存</button>
  86.     </div>
  87. </div>
  89. <script type="text/javascript" src="/static/wangEditor/release/wangEditor.js"></script>
  90. <script type="text/javascript">
  91.     var E = window.wangEditor;
  92.     var editor = new E('#editor');
  93.     // 或者 var editor = new E( document.getElementById('editor') )
  94.     editor.create();
  95.     editor.txt.html('<?php echo htmlspecialchars_decode($data['info']); ?>');
  96.     layui.use(['layer','form', 'upload'],function(){
  97.         form = layui.form;
  98.         layer = layui.layer;
  99.         $ = layui.jquery;
  100.         upload = layui.upload;
  101.         var uploadInst = upload.render({
  102.             elem: '#test1'
  103.             ,url: '/index.php/admins/Home/up_img'
  104.             ,before: function(obj){
  105.                 //预读本地文件示例，不支持ie8
  106.                 obj.preview(function(index, file, result){
  107.                     $('#demo1').attr('src', result); //图片链接（base64）
  108.                 });
  109.             }
  110.             ,done: function(res){
  111.                 //如果上传失败
  112.                 if(res.code > 0){
  113.                     return layer.msg('上传失败');
  114.                 }else{
  115.                     $('#demo1').attr('src', res.data); //图片链接（base64）
  116.                     $('input[name="img"]').val(res.data); //图片链接（base64）
  117.                 }
  118.                 //上传成功
  119.             }
  120.             ,error: function(){
  121.                 //演示失败状态，并实现重传
  122.                 var demoText = $('#demoText');
  123.                 demoText.html('<span style="color: #FF5722;">上传失败</span> <a class="layui-btn layui-btn-xs demo-reload">重试</a>');
  124.                 demoText.find('.demo-reload').on('click', function(){
  125.                     uploadInst.upload();
  126.                 });
  127.             }
  128.         });
  129.     });
  131.     // 保存管理员
  132.     function save(){
  133.         // 用js 获取省名称 首字母
  134.         var title = $.trim($('input[name="title"]').val());
  135.         if(title==''){
  136.             layer.alert('请输入标题',{icon:2});
  137.             return;
  138.         }
  139.         var data = new Object();
  140.         data.id = $('input[name="id"]').val();
  141.         data.title = $('input[name="title"]').val();
  142.         data.price = $('input[name="pirce"]').val();
  143.         data.o_price = $('input[name="o_price"]').val();
  144.         data.img = $('input[name="img"]').val();
  145.         data.info = editor.txt.html();
  146.         data.sort = $('input[name="sort"]').val();
  147.         data.status = $('input[name="status"]').val();
  148.         // 请求保存接口，把数据传值到接口中。
  149.         $.post('/index.php/admins/Shop/shop_save',data,function(res){
  150.             if(res.code>0){
  151.                 layer.alert(res.msg,{icon:2});
  152.             }else{
  153.                 layer.msg(res.msg);
  154.                 setTimeout(function(){parent.window.location.reload();},1000);
  155.             }
  156.         },'json');
  157.     }
  159. </script>
  160. </body>
  161. </html>
三、用户管理

这里只需要查询到所有的用户 然后展示出来就可以

  1. //用户列表
  2.     public function index() {
  3.         //查找所有用户按照uid降序
  4.         $list = $this->db->table('shop_user')->order('uid DESC')->lists();
  5.         $this->assign('list', $list);
  6.         $address = $this->db->table('shop_city')->where(array('status'=>1))->cates('id');
  7.         $this->assign('address', $address);
  8.         return $this->fetch();
  9.     }
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4.     <title></title>
  5.     <link rel="stylesheet" type="text/css" href="/static/plugins/layui/css/layui.css">
  6.     <script type="text/javascript" src="/static/plugins/layui/layui.js"></script>
  7.     <style type="text/css">
  8.         .header span{background: #009688;margin-left: 30px;padding: 10px;color:#ffffff;}
  9.         .header div{border-bottom: solid 2px #009688;margin-top: 8px;}
  10.         .header button{float: right;margin-top: -5px;}
  11.     </style>
  12. </head>
  13. <body style="padding: 10px;">
  14. <div class="header">
  15.     <span>用户列表</span>
  16.     <div></div>
  17. </div>
  19. <table class="layui-table">
  20.     <thead>
  21.     <tr>
  22.         <th>ID</th>
  23.         <th>昵称</th>
  24.         <th>电话</th>
  25.         <th>性别</th>
  26.         <th>省市区</th>
  27.         <th>状态</th>
  28.     </tr>
  29.     </thead>
  30.     <tbody>
  31.     <!-- 循环出所有用户      -->
  32.     {volist name="list" id="vo"}
  33.     <tr>
  34.         <td>{$vo.uid}</td>
  35.         <td>{$vo.nickname}</td>
  36.         <td>{$vo.phone}</td>
  37.         <td>
  38.             {if condition="$vo.sex == 1"}<span style="color: green;">男</span>
  39.             {elseif condition="$vo.sex == 2" /}<span style="color: red;">女</span>
  40.             {else/}未知
  41.             {/if}
  42.         </td>
  43.         <td>{$address[$vo.province]['name']}{$address[$vo.city]['name']}{$address[$vo.area]['name']}</td>
  44.         <td>{if condition="$vo.status == 1"}<span style="color: green;">开启</span>{else/}<span style="color: red;">关闭</span>{/if}</td>
  45.     </tr>
  46.     {/volist}
  47.     </tbody>
  48. </table>
  49. </body>
  50. </html>
四、订单管理

查询出所有总订单列表展示出来，可以查看子订单，可以发货。这里主要是数据库的数据需要转化成相应的文字，产看子订单就是根据order_id在子订单表理查询出来，发货是弹出新页面，选择快递、单号，然后发送给保存方法，同时还有order_id，发货时间、发货状态，然后修改数据库数据

  1. //订单列表
  2.     public function order() {
  3.         //按照添加时间降序查询出所有订单信息
  4.         $list = $this->db->table('shop_order')->order('add_time DESC')->lists();
  5.         $this->assign('list', $list);
  6.         return $this->fetch();
  7.     }
  8.     //子订单页面
  9.     public function order_two() {
  10.         $id = (int)input('get.id');
  11.         $list = $this->db->table('shop_order_son')->where(array('order_id'=>$id))->lists();
  12.         $this->assign('list', $list);
  13.         $user = $this->db->table('shop_order')->where(array('order_id'=>$id))->item();
  14.         $uid = $user['uid'];
  15.         $people = $this->db->table('shop_user')->where(array('uid'=>$uid))->item();
  16.         $nickname = $people['nickname'];
  17.         $this->assign('nickname', $nickname);
  18.         return $this->fetch();
  19.     }
  20.     //发货
  21.     public function send_goods() {
  22.         $order_id = (int)input('get.id');
  23.         $this->assign('order_id', $order_id);
  24.         return $this->fetch();
  25.     }
  26.     //发货保存
  27.     public function order_save() {
  28.         $id = (int)input('post.id');
  29.         $data['express'] = trim(input('post.express'));
  30.         $data['express_id'] = trim(input('post.express_id'));
  31.         $data['deliver_time'] = time();
  32.         $data['status'] = 3;
  33.         //修改
  34.         $add = $this->db->table('shop_order')->where(array('order_id'=>$id))->update($data);
  35.         if($add > 0){
  36.             exit(json_encode(array('code'=>0,'msg'=>'发货成功')));
  37.         }else{
  38.             exit(json_encode(array('code'=>1,'msg'=>'发货失败')));
  39.         }
  41.     }
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4.     <title></title>
  5.     <link rel="stylesheet" type="text/css" href="/static/plugins/layui/css/layui.css">
  6.     <script type="text/javascript" src="/static/plugins/layui/layui.js"></script>
  7.     <style type="text/css">
  8.         .header span{background: #009688;margin-left: 30px;padding: 10px;color:#ffffff;}
  9.         .header div{border-bottom: solid 2px #009688;margin-top: 8px;}
  10.         .header button{float: right;margin-top: -5px;}
  11.     </style>
  12. </head>
  13. <body style="padding: 10px;">
  14. <div class="header">
  15.     <span>订单列表</span>
  16.     <div></div>
  17. </div>
  19. <table class="layui-table">
  20.     <thead>
  21.     <tr>
  22.         <th>ID</th>
  23.         <th>第三方ID</th>
  24.         <th>支付方式</th>
  25.         <th>总价</th>
  26.         <th>支付价格</th>
  27.         <th>用户id</th>
  28.         <th>地址</th>
  29.         <th>手机</th>
  30.         <th>快递</th>
  31.         <th>时间</th>
  32.         <th>状态</th>
  33.         <th>操作</th>
  34.     </tr>
  35.     </thead>
  36.     <tbody>
  37.     <!-- 循环出所有用户      -->
  38.     {volist name="list" id="vo"}
  39.     <tr>
  40.         <td>{$vo.order_id}</td>
  41.         <td>{$vo.orders_id}</td>
  42.         <td>
  43.             {if condition="$vo.pay_mode == 1"}支付宝{/if}
  44.             {if condition="$vo.pay_mode == 2"}微信{/if}
  45.             {if condition="$vo.pay_mode == 3"}PayPal{/if}
  46.             {if condition="$vo.pay_mode == 4"}线下支付{/if}
  47.         </td>
  48.         <td>{$vo.price}</td>
  49.         <td>{$vo.pay_price}</td>
  50.         <td>{$vo.uid}</td>
  51.         <td>{$vo.address}</td>
  52.         <td>{$vo.phone}</td>
  53.         <td>
  54.             {if condition="$vo.express == 1"}顺丰：{$vo.express_id}{/if}
  55.             {if condition="$vo.express == 2"}韵达：{$vo.express_id}{/if}
  56.             {if condition="$vo.express == 3"}中通：{$vo.express_id}{/if}
  57.         </td>
  58.         <td>
  59.             支付时间：{$vo.pay_time|date="Y-m-d H:i:s"}<br/>
  60.             发货时间：{$vo.deliver_time|date="Y-m-d H:i:s"}<br/>
  61.             收货时间：{$vo.receiv_time|date="Y-m-d H:i:s"}<br/>
  62.         </td>
  63.         <td>
  64.             {if condition="$vo.status == 1"}<span style="color: red;">未支付</span>{/if}
  65.             {if condition="$vo.status == 2"}<span style="color: red;">已支付 未发货</span>{/if}
  66.             {if condition="$vo.status == 3"}<span style="color: red;">已发货 未收货</span>{/if}
  67.             {if condition="$vo.status == 4"}<span style="color: red;">已收货 未评论</span>{/if}
  68.             {if condition="$vo.status == 5"}<span style="color: red;">已退货</span>{/if}
  69.             {if condition="$vo.status == 10"}<span style="color: red;">已关闭</span>{/if}
  70.         </td>
  71.         <td>
  72.             <button class="layui-btn layui-btn-xs" onclick="add({$vo.order_id})">子订单</button>
  73.             <button class="layui-btn layui-btn-danger layui-btn-xs" onclick="del({$vo.order_id})">发货</button>
  74.         </td>
  75.     {/volist}
  76.     </tbody>
  77. </table>
  78. <script type="text/javascript">
  79.     layui.use(['layer'],function(){
  80.         layer = layui.layer;
  81.         $ = layui.jquery;
  82.     });
  83.     //跳转到子订单
  84.     function add(id) {
  85.         window.location.href = '/index.php/admins/User/order_two?id='+id;
  86.     }
  87.     //弹出发货页面
  88.     function del(id) {
  89.         layer.open({
  90.             type: 2,
  91.             title: '发货',
  92.             shade: 0.3,
  93.             area: ['1080px', '600px'],
  94.             content: '/index.php/admins/User/send_goods?id=' + id
  95.         });
  96.     }
  97. </script>
  98. </body>
  99. </html>
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4.     <title></title>
  5.     <link rel="stylesheet" type="text/css" href="/static/plugins/layui/css/layui.css">
  6.     <script type="text/javascript" src="/static/plugins/layui/layui.js"></script>
  7.     <style type="text/css">
  8.         .header span{background: #009688;margin-left: 30px;padding: 10px;color:#ffffff;}
  9.         .header div{border-bottom: solid 2px #009688;margin-top: 8px;}
  10.         .header button{float: right;margin-top: -5px;}
  11.     </style>
  12. </head>
  13. <body style="padding: 10px;">
  14. <div class="header">
  15.     <span style="background-color:#999;"><a href="/index.php/admins/User/order" style="color:#fff;">总订单</a></span>
  16.     <span>{$nickname}的子订单</span>
  17.     <div></div>
  18. </div>
  20. <table class="layui-table">
  21.     <thead>
  22.     <tr>
  23.         <th>ID</th>
  24.         <th>总订单ID</th>
  25.         <th>商品ID</th>
  26.         <th>价格</th>
  27.         <th>数量</th>
  28.     </tr>
  29.     </thead>
  30.     <tbody>
  31.     <!-- 循环出所有用户      -->
  32.     {volist name="list" id="vo"}
  33.     <tr>
  34.         <td>{$vo.id}</td>
  35.         <td>{$vo.order_id}</td>
  36.         <td>{$vo.goods_id}</td>
  37.         <td>{$vo.price}</td>
  38.         <td>{$vo.number}</td>
  39.     {/volist}
  40.     </tbody>
  41. </table>
  42. </body>
  43. </html>
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4.     <title></title>
  5.     <link rel="stylesheet" type="text/css" href="/static/plugins/layui/css/layui.css">
  6.     <script type="text/javascript" src="/static/plugins/layui/layui.js"></script>
  7. </head>
  8. <body style="padding: 10px;">
  9. <form class="layui-form">
  10.     <input type="hidden" name="id" value="{$order_id}">
  11.     <div class="layui-form-item">
  12.         <label class="layui-form-label">快递</label>
  13.         <div class="layui-input-inline">
  14.             <select name="express">
  15.                 <option value="1">顺丰</option>
  16.                 <option value="2">韵达</option>
  17.                 <option value="3">中通</option>
  18.             </select>
  19.         </div>
  20.     </div>
  21.     <div class="layui-form-item">
  22.         <label class="layui-form-label">快递单号</label>
  23.         <div class="layui-input-inline">
  24.             <input type="text" class="layui-input" name="express_id">
  25.         </div>
  26.     </div>
  27. </form>
  28. <div class="layui-form-item">
  29.     <div class="layui-input-block">
  30.         <button class="layui-btn" onclick="save()">保存</button>
  31.     </div>
  32. </div>
  34. <script type="text/javascript">
  35.     layui.use(['layer','form'],function(){
  36.         form = layui.form;
  37.         layer = layui.layer;
  38.         $ = layui.jquery;
  39.     });
  41.     // 保存管理员
  42.     function save(){
  43.         var express_id = $.trim($('input[name="express_id"]').val());
  44.         if(express_id==''){
  45.             layer.alert('请输入快递单号',{icon:2});
  46.             return;
  47.         }
  48.         // 请求保存接口，把数据传值到接口中。
  49.         $.post('/index.php/admins/User/order_save',$('form').serialize(),function(res){
  50.             if(res.code>0){
  51.                 layer.alert(res.msg,{icon:2});
  52.             }else{
  53.                 layer.msg(res.msg);
  54.                 setTimeout(function(){parent.window.location.reload();},1000);
  55.             }
  56.         },'json');
  57.     }
  59. </script>
  60. </body>
  61. </html>
Correction status：Uncorrected

Teacher's comments：
Statement of this Website
The copyright of this blog article belongs to the blogger. Please specify the address when reprinting! If there is any infringement or violation of the law, please contact admin@php.cn Report processing!
All comments Speak rationally on civilized internet, please comply with News Comment Service Agreement
0 comments
Author's latest blog post