产品模块的增删改查

Original 2019-05-18 14:29:14 256
abstract:通过本章的学习,实现了产品模块的增删改查,代码如下:控制器:Product.php<?php namespace app\admin\controller; use app\admin\model\product\ProductModel; use app\admin\model\sort\SortModel; use think\facade\

通过本章的学习,实现了产品模块的增删改查,代码如下:

控制器:Product.php

<?php

namespace app\admin\controller;


use app\admin\model\product\ProductModel;
use app\admin\model\sort\SortModel;
use think\facade\Request;
use think\facade\Session;

class Product extends  Check
{
    public  function  index()
    {
        $paginate = 3;
        $this->view->paginate=$paginate;

        $count = ProductModel::count();
        $this->view->count=$count;

        $product =ProductModel::order('time','desc')->paginate($paginate);
        $this->view->product = $product;

        return $this->view->fetch();
    }

    public  function  add()
    {
        $sorts = SortModel::all();
        $this->view->sorts=$sorts;

        return $this->view->fetch();
    }

    public  function  edit()
    {
        $id=Request::param('id');

        $product = ProductModel::get($id);
        $this->view->product=$product;

        return $this->view->fetch();
    }

    public  function  upload()
    {
        $file = Request::file('img');

        if($res = $file->validate(['ext'=>'jpg,jpeg,png,gif'])->move('upload'))
        {
            return json(['errno'=>0,'msg'=>'上传成功','data'=>['/upload/'.$res->getSaveName()]]);
        }
        else
        {
            return $file->getError();
        }

    }

    public function  doAdd()
    {
        $data = Request::param();
        $data['time']=time();
        $data['username']=Session::get('user');

        $title = $data['title'];
        $info = ProductModel::getByTitle($title);
        if ($info == true) {
            return ['res' => 0, 'msg' => '产品标题重复!'];
        }

        $product = new ProductModel();

        if($product->save($data))
        {
            return ['res'=>1,'msg'=>'添加成功'];
        }
        else
        {
            return ['res'=>0,'msg'=>'添加失败'];
        }
    }

    public function  doEdit()
    {
        $data = Request::param();
        $data['time']=time();
        $data['username']=Session::get('user');

        $product = new ProductModel();

        if($product->save($data,['id'=>$data['id']]))
        {
            return ['res' => 1, 'msg' => '更新成功!'];
        } else {
            return ['res' => 0, 'msg' => '更新失败!'];
        }

    }

    public  function  doDel()
    {
        $id=Request::param('id');

        $product = new ProductModel();

        if($product->destroy($id))
        {
            return ['res'=>1,'msg'=>'删除成功!'];
        }
        else
        {
            return ['res'=>0,'msg'=>'删除失败!'];
        }
    }
}

模型:ProductModel.php

<?php
namespace app\admin\model\product;


use think\Model;

class ProductModel extends  Model
{
    protected  $table='product';

    protected $pk='id';
}

视图:index.html

{include file="/public/header" /}

<body>
<div class="x-nav">
      <span class="layui-breadcrumb">
        <a href="">首页</a>
        <a href="">演示</a>
        <a>
          <cite>导航元素</cite></a>
      </span>
    <a class="layui-btn layui-btn-small" style="line-height:1.6em;margin-top:3px;float:right" href="javascript:location.replace(location.href);" title="刷新">
        <i class="layui-icon" style="line-height:30px">ဂ</i></a>
</div>
<div class="x-body">
    <xblock>
        <button class="layui-btn" onclick="x_admin_show('添加产品','{:url(\'Product/add\')}')"><i class="layui-icon"></i>添加</button>
        <span class="x-right" style="line-height:40px">共有数据:{$count}条。每页:{$paginate}条。</span>
    </xblock>
    <table class="layui-table">
        <thead>
        <tr>
            <th>产品ID</th>
            <th>产品标题</th>
            <th>产品分类</th>
            <th>产品图片</th>
            <th>产品简介</th>
            <th>发布管理员</th>
            <th>发布日期</th>
            <th >操作</th>
        </tr>
        </thead>
        <tbody>
        {volist name="product" id="list"}
        <tr>
            <td>{$list.id}</td>
            <td>{$list.title}</td>
            <td>{$list.sort}</td>
            <td><img src="{:GetProPic($list.id)}" /></td>
            <td width="50%">{$list.desc}</td>
            <td>{$list.username}</td>
            <td>{$list.time|date="Y-m-d H:i:s"}</td>
            <td class="td-manage">
                <a title="查看"  onclick="x_admin_show('编辑','{:url(\'edit\')}'+'?id='+{$list.id})" href="javascript:;">
                    <i class="layui-icon">&#xe63c;</i>
                </a>
                <a title="删除" onclick="member_del(this,'{$list.id}')" href="javascript:;">
                    <i class="layui-icon">&#xe640;</i>
                </a>
            </td>
        </tr>
        {/volist}
        </tbody>
    </table>
    <div class="page">
        <div>
            {$product|raw}
        </div>
    </div>

</div>
<script>
    layui.use('laydate', function(){
        var laydate = layui.laydate;

        //执行一个laydate实例
        laydate.render({
            elem: '#start' //指定元素
        });

        //执行一个laydate实例
        laydate.render({
            elem: '#end' //指定元素
        });
    });

    /*用户-删除*/
    function member_del(obj,id){
        layer.confirm('确认要删除吗?',function(index){
            $.post('{:url("doDel")}',{
                'id':id
            },function (data) {
                if(data.res==1)
                {
                    //发异步删除数据
                    $(obj).parents("tr").remove();
                    layer.msg(data.msg,{icon:1,time:1000});
                }
                else
                {
                    layer.msg(data.msg,{icon:1,time:1000});
                }
            })

        });
    }
</script>
</body>

</html>

add.html

{include file="/public/header"}
<body>
<div class="x-body">
    <form class="layui-form">
        <div class="layui-form-item">
            <label for="title" class="layui-form-label">
                <span class="x-red">*</span>产品标题
            </label>
            <div class="layui-input-inline">
                <input type="text" id="title" name="title" required="" lay-verify="required"
                       autocomplete="off" class="layui-input">
            </div>
        </div>
        <div class="layui-form-item">
            <label for="sort" class="layui-form-label">
                <span class="x-red">*</span>产品分类
            </label>
            <div class="layui-input-inline">
                <select id="sort" name="sort" class="valid">
                    {volist name="sorts" id="sort"}
                    <option value="{$sort.name}">{$sort.name}</option>
                    {/volist}
                </select>
            </div>
        </div>
        <div class="layui-form-item">
            <label for="desc" class="layui-form-label">
                <span class="x-red">*</span>简介
            </label>

            <div class="layui-input-inline">
                <textarea placeholder="请输入内容" id="desc" name="desc" class="layui-textarea"></textarea>
            </div>
        </div>
        <div class="layui-form-item layui-form-text">
            <label for="desc" class="layui-form-label">
                内容
            </label>
            <div class="layui-input-block" id="editor">
            </div>
        </div>
        <div class="layui-form-item">
            <label for="once" class="layui-form-label">
                <span class="x-red">*</span>一次价格
            </label>
            <div class="layui-input-inline">
                <input type="text" id="once" name="once" required="" lay-verify="required"
                       autocomplete="off" class="layui-input">
            </div>
        </div>
        <div class="layui-form-item">
            <label for="over_night" class="layui-form-label">
                <span class="x-red">*</span>一夜价格
            </label>
            <div class="layui-input-inline">
                <input type="text" id="over_night" name="over_night" required="" lay-verify="required"
                       autocomplete="off" class="layui-input">
            </div>
        </div>
        <div class="layui-form-item">
            <label for="L_repass" class="layui-form-label">
            </label>
            <button class="layui-btn" lay-filter="add" lay-submit="">
                发布
            </button>
        </div>
    </form>
</div>
<script type="text/javascript" src="__ADMIN__/js/wangEditor.js"></script>
<script>
    layui.use(['form', 'layer'], function () {
        $ = layui.jquery;
        var form = layui.form
            , layer = layui.layer;

        //配置wangEditor富文本编辑器
        ////将要用到的对象添加到全局
        var E = window.wangEditor

        //生成editor对象
        var editor = new E('#editor')

        //设置图片上传的控件名称:类似于input的name属性,供接口获取图片信息使用
        editor.customConfig.uploadFileName = 'img'

        //设置服务上的图片上传处理接口脚本
        editor.customConfig.uploadImgServer = '{:url("upload")}'

        //创建出富文件编辑器
        editor.create()

        //自定义验证规则
        form.verify({
            nikename: function (value) {
                if (value.length < 5) {
                    return '产品标题至少得5个字符啊';
                }
            }
        });

        //监听提交
        form.on('submit(add)', function (data) {
            console.log(data);
            //发异步,把数据提交给php
            $.post('{:url(\'doAdd\')}', {
                'title': $('#title').val(),
                'sort': $('#sort').val(),
                'desc': $('#desc').val(),
                'once_money':$('#once').val(),
                'over_night_money':$('#over_night').val(),
                'content': editor.txt.html(),
            }, function (data) {
                if (data.res == 1) {
                    layer.alert(data.msg, {icon: 6}, function () {
                        // 获得frame索引
                        var index = parent.layer.getFrameIndex(window.name);
                        //关闭当前frame
                        parent.layer.close(index);
                        //刷新父窗口
                        parent.location.reload();
                    });
                } else {
                    layer.alert(data.msg, {icon: 6});
                }
            })


            return false;
        });
    });
</script>
</body>

</html>

edit.html

{include file="/public/header"}
<body>
<div class="x-body">
    <form class="layui-form">
        <div class="layui-form-item">
            <label for="title" class="layui-form-label">
                <span class="x-red">*</span>产品标题
            </label>
            <div class="layui-input-inline">
                <input type="text" id="title" name="title" value="{$product.title}" required="" lay-verify="required"
                       autocomplete="off" class="layui-input">
                <input type="hidden" id="id" name="id" value="{$product.id}">
            </div>
        </div>
        <div class="layui-form-item">
            <label for="desc" class="layui-form-label">
                <span class="x-red">*</span>简介
            </label>

            <div class="layui-input-inline">
                <textarea placeholder="请输入内容" id="desc" name="desc" class="layui-textarea">{$product.desc}</textarea>
            </div>
        </div>
        <div class="layui-form-item layui-form-text">
            <label for="desc" class="layui-form-label">
                内容
            </label>
            <div class="layui-input-block" id="editor">
                {:htmlspecialchars_decode($product.content)}
            </div>
        </div>
        <div class="layui-form-item">
            <label for="once" class="layui-form-label">
                <span class="x-red">*</span>一次价格
            </label>
            <div class="layui-input-inline">
                <input type="text" id="once" name="once" value="{$product.once_money}" required="" lay-verify="required"
                       autocomplete="off" class="layui-input">
            </div>
        </div>
        <div class="layui-form-item">
            <label for="over_night" class="layui-form-label">
                <span class="x-red">*</span>一夜价格
            </label>
            <div class="layui-input-inline">
                <input type="text" id="over_night" name="over_night" value="{$product.over_night_money}" required=""
                       lay-verify="required"
                       autocomplete="off" class="layui-input">
            </div>
        </div>
        <div class="layui-form-item">
            <label for="L_repass" class="layui-form-label">
            </label>
            <button class="layui-btn" lay-filter="add" lay-submit="">
                修改
            </button>
        </div>
    </form>
</div>
<script type="text/javascript" src="__ADMIN__/js/wangEditor.js"></script>
<script>
    layui.use(['form', 'layer'], function () {
        $ = layui.jquery;
        var form = layui.form
            , layer = layui.layer;

        //配置wangEditor富文本编辑器
        ////将要用到的对象添加到全局
        var E = window.wangEditor

        //生成editor对象
        var editor = new E('#editor')

        //设置图片上传的控件名称:类似于input的name属性,供接口获取图片信息使用
        editor.customConfig.uploadFileName = 'img'

        //设置服务上的图片上传处理接口脚本
        editor.customConfig.uploadImgServer = '{:url("upload")}'

        //创建出富文件编辑器
        editor.create()

        //自定义验证规则
        form.verify({
            nikename: function (value) {
                if (value.length < 5) {
                    return '产品标题至少得5个字符啊';
                }
            }
        });

        //监听提交
        form.on('submit(add)', function (data) {
            console.log(data);
            //发异步,把数据提交给php
            $.post('{:url(\'doEdit\')}', {
                'id': $('#id').val(),
                'title': $('#title').val(),
                'desc': $('#desc').val(),
                'content': editor.txt.html(),
                'once_money': $('#once').val(),
                'over_night_money': $('#over_night').val(),
            }, function (data) {
                if (data.res == 1) {
                    layer.alert(data.msg, {icon: 6}, function () {
                        // 获得frame索引
                        var index = parent.layer.getFrameIndex(window.name);
                        //关闭当前frame
                        parent.layer.close(index);
                        //刷新父窗体
                        parent.location.reload();
                    });
                } else {
                    layer.alert(data.msg, {icon: 6});
     &					

Correcting teacher:查无此人Correction time:2019-05-20 09:10:10
Teacher's summary:完成的不错。后台cms管理系统,就是对数据进行操作。操作越简单越好。继续加油

Release Notes

Popular Entries