ytapi/application/admin/controller/Owner.php

<?php
namespace app\admin\controller;
use think\Controller;
use think\Session;
use think\Db;
use think\Request;
class Owner extends Controller
{	
       public function index()
    {
       $data_list =Db::table('owner')->paginate();

        $pages = $data_list->render();
        $this->assign('data_list', $data_list);
        $this->assign('pages', $pages); 
        return $this->fetch();
    }

        public function add()
    {
        if ($this->request->isPost()) {
            $data=$_POST;

            //验证数据
            if(empty($data['name'])||empty($data['host'])||empty($data['port'])){
                return $this->error("请填写好必要内容");
            }
            $is=Db::name('owner')->where('name',$data['name'])->find();
            if($is) return $this->error("该业主已经存在");

            //添加
            $list=array();
            $list['name']= $data['name'];
            $list['host']= $data['host'];
            $list['port']= $data['port'];
            $list['addtime']= date('Y-m-d H:i:s');

            $res = Db::name('owner')->insertGetId($list);
            if($res) {
                return $this->success('添加成功','index');
            }else{
                return $this->error("添加失败，请稍后再试");
            }
               
        }

        return $this->fetch();
    }


    public function edit()
    {
        $res=Db::name('owner')->where('id',input('id'))->find();
        

        if ($this->request->isPost()) {
            $data=$_POST;
           //验证数据
            if(empty($data['name'])||empty($data['host'])||empty($data['port'])){
                return $this->error("请填写好必要内容");
            }
            

            if($res["name"]!=$data['name']){
                $is=Db::name('owner')->where('name',$data['name'])->find();
                  if($is) return $this->error("该业主已经存在");
            }
          
            
             //添加
            $list=array();
            $list['name']= $data['name'];
            $list['host']= $data['host'];
            $list['port']= $data['port'];
            $list['addtime']= date('Y-m-d H:i:s');


            $res1 = Db::name('owner')->where('id',$data['id'])->update($list);
            
            if($res1) return $this->success('编辑成功','index');
            else return $this->error('编辑失败！');
        }

        $this->assign('data', $res);
        return $this->fetch();
    }


    public function delete()
    {
         $data=input('');

         $res= Db::name("owner")->where("id",$data['id'])->delete();
            if($res) {
                return $this->success('删除成功','index');
            }else{
                return $this->error("删除失败，请稍后再试");
            }
    }

 
}