<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2019/10/31
 * Time: 15:36
 */

namespace app\admin\controller;


use cmf\controller\AdminBaseController;
use think\Db;
use think\Validate;

class AttrController extends AdminBaseController
{
    public function index()
    {
        $where = [];
        $param = $this->request->param();
        $keyword = empty($param['keyword']) ? '' : $param['keyword'];
        if (!empty($keyword)) {
            $where['a.attr_name'] = ['like', "%$keyword%"];
        }
        $data = Db::name('attr')
            ->alias('a')
            ->join('rgoods r','a.rgoods_id = r.id')
            ->field('a.*,r.rgoods_name')
            ->where($where)
            ->order('a.id desc')
            ->paginate(10);
        $list=$data->items();
        $this->assign([
            'keyword'=>$keyword,
            'data'=>$list,
            'page'=>$data->render(),
        ]);
        return $this->fetch();
    }

    //添加
    public function add()
    {
        if($this->request->isPost()){
            $param=$this->request->param();
            $param['create_time']=time();
            $validate = new Validate([
                'attr_name'=>'require',
                'attr_price'=>'require'
            ]);
            $validate->message([
                'attr_name'=>'属性名称不能为空',
                'attr_price'=>'属性对应价格不能为空'
            ]);
            if (!$validate->check($param)) {
                $this->error($validate->getError());
            }

            Db::name('attr')
                ->insert($param);
            $this->success('添加成功！','index');

        }else{
            return $this->fetch();
        }
    }

    //编辑
    public function edit(){
        $id=$this->request->param('id', 0, 'intval');
        if($this->request->isPost()){
            $param=$this->request->param();
            $validate = new Validate([
                'attr_name'=>'require',
                'attr_price'=>'require'
            ]);
            $validate->message([
                'attr_name'=>'属性名称不能为空',
                'attr_price'=>'属性对应价格不能为空'
            ]);
            if (!$validate->check($param)) {
                $this->error($validate->getError());
            }
            $param['update_time'] = time();
            $data = Db::name('attr')
                ->where('id',$id)
                ->update($param);
            if($data){
                $this->success('更新成功！');
            }else{
                $this->error('sql执行错误');
            }

        }else{
            $data=Db::name('attr')
                ->where('id',$id)
                ->find();
            $data['rgoods'] = Db::name('rgoods')->whereIn('id',$data['rgoods_id'])->field('id,rgoods_name')->select();
            $keyword = $this->request->param('keyword');
            $this->assign('keyword', isset($keyword) ? $keyword : '');
            $this->assign('data',$data);
            return $this->fetch();
        }
    }


    //删除
    public function delete(){
        $param = $this->request->param();
        if (isset($param['id'])) {
            $id = $this->request->param('id', 0, 'intval');
            $resultPortal = Db::name('attr')
                ->where(['id' => $id])
               ->delete();
            if($resultPortal){
                $this->success("删除成功", '');
            }else{
                $this->error("删除失败", '');
            }
        }

        if (isset($param['ids'])) {
            $ids = $this->request->param('ids/a');
            $result = Db::name('attr')
                ->where(['id' => ['in', $ids]])
               ->delete();
            if ($result) {
                $this->success("删除成功", '');
            }else{
                $this->error("删除失败", '');
            }
        }
    }
}