商品多图保存在一条数据里面

<?php
namespace app\admin\controller;

use think\Controller;
use \think\Db;


/*商品详情列表*/
class ProductList extends Controller
{
    public function index()
    {

        $admin_product_list = db('product_list')->select(); //详情
        //dump($admin_product_list);die;
        foreach ($admin_product_list as $k => $v){
            $admin_product_list[$k]['carousel_images'] = json_decode($v['carousel_images']);
            $admin_product_list[$k]['details_images'] = json_decode($v['details_images']);
        }
        //dump($admin_product_list);

        //所属分类
        $fenlei_column_info = db('fenlei_column')->select();

        $this->assign(array(
            'admin_product_list'=>$admin_product_list,
            'fenlei_column_info'=>$fenlei_column_info,
        ));

        return $this->fetch('index');
    }


    //添加商品详情
    public function add()
    {
        if(request()->isPost())
        {

            $data = [
                'name'=>$this->request->param('name'),
                'price'=>$this->request->param('price'),
                'sold_num'=>$this->request->param('sold_num'),
                'fenlei_column_id'=>$this->request->param('fenlei_column_id'),
                'original_price'=>$this->request->param('original_price'),
                'goods_stock_num'=>$this->request->param('goods_stock_num'),
                'certified_products'=>$this->request->param('certified_products'),
                'speed_goods'=>$this->request->param('speed_goods'),
                'days_return_goods'=>$this->request->param('days_return_goods'),
                'create_time'=>date("Y-m-d H:i:s",time()),
            ];

            // dump($data);die;
            // 获取表单上传文件 例如上传了001.jpg
            //----thumb商品分类图片
            $file = request()->file('thumb');
            // dump($file);die;
            // 移动到框架应用根目录/public/uploads/category/ 目录下
            if($file){
                $info = $file->move(ROOT_PATH . 'public' . DS . 'uploads/spfl/thumb');
                //dump($info);die;

                if($info){
                    // 成功上传后 获取上传信息
                    // 输出 jpg
                    $imgs =str_replace("\\","/",$info->getSaveName());
                    $data['thumb'] = '/uploads/spfl/thumb/'.$imgs;
                    // 输出 20160820/42a79759f284b767dfcb2a0197904287.jpg
                }else{
                    // 上传失败获取错误信息
                    echo $file->getError();
                }
            }


            //商品详细轮播图
            $file_carousel_images = request()->file('carousel_images');
            $data_carousel_images = array();
            if($file_carousel_images) {
                foreach ($file_carousel_images as $files_carousel_images) {
                    $info = $files_carousel_images->move(ROOT_PATH . 'public' . DS . 'uploads/splb/carousel_images');
                    //dump($info);die;
                    if ($info) {
                        $imgs  = str_replace("\\", "/", $info->getSaveName());
                        $data_carousel_images[] = '/uploads/splb/carousel_images/' . $imgs;
                        // 输出 20160820/42a79759f284b767dfcb2a0197904287.jpg
                    } else {
                        // 上传失败获取错误信息
                        echo $files_carousel_images->getError();
                    }
                }
            }

            //商品详情图
            $file_details_images = request()->file('details_images');
            $data_details_images = array();
            if($file_details_images) {
                foreach ($file_details_images as $files_details_images) {
                    $info = $files_details_images->move(ROOT_PATH . 'public' . DS . 'uploads/spxq/details_images');
                    //dump($info);die;
                    if ($info) {
                        $imgs  = str_replace("\\", "/", $info->getSaveName());
                        $data_details_images[] = '/uploads/spxq/details_images/' . $imgs;
                        // 输出 20160820/42a79759f284b767dfcb2a0197904287.jpg
                    } else {
                        // 上传失败获取错误信息
                        echo $files_details_images->getError();
                    }
                }
            }

            $data['carousel_images'] =json_encode($data_carousel_images); //商品轮播图
            $data['details_images'] = json_encode($data_details_images); //商品详情图
            $res = db('product_list')->insert($data);
            if($res){
                $this->success('添加商品详情内容成功!','index');
            }else{
                $this->error('添加商品详情内容失败!');
            }
        }
        $columnInfo = db('fenlei_column')->select();
        $this->assign('columnInfo',$columnInfo);
        return $this->fetch();
    }

    //编辑分类
    public function edit($id)
    {
        if(request()->isPost()){
            $data = [
                'cate_name'=>input('cate_name')
            ];
            $res = db('fenlei_category')->where('id',$id)->update($data);
            if($res){
                $this->success('编辑分类成功','index');
            }else{
                $this->error('编辑分类失败');
            }
        }
        $categorys = db('fenlei_category')->where('id',$id)->find();
        $this->assign('categorys',$categorys);
        return $this->fetch();
    }










}

 

posted @ 2019-06-26 11:44  搬砖小伙子  阅读(254)  评论(0编辑  收藏  举报