search

博客列表 >CMS后台管理商城系统（三） 商品分类管理 商品管理 用户列表 订单列表

CMS后台管理商城系统（三） 商品分类管理 商品管理 用户列表 订单列表

小明的博客
小明的博客原创
2020年02月25日 23:43:293111浏览

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

一、商品分类管理
商品分类主要功能是新建商品一级分类列表，有添加、编辑、删除功能，还有二级分类列表。添加编辑，更具传入的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>
上一条：0218 PHP单例模式与应用场景工厂模式的优缺点下一条：生活一如既往的轻松
声明：本文内容转载自脚本之家，由网友自发贡献，版权归原作者所有，如您发现涉嫌抄袭侵权，请联系admin@php.cn 核实处理。
全部评论
文明上网理性发言，请遵守新闻评论服务协议

相关文章

查看更多