<?php
/**
 * 彩蛋设置

 * Set.php
 * User: ChenLong
 * DateTime: 2020-04-27 12:58
 */

namespace app\admin\controller;

use sdModule\layuiSearch\SearchForm;
use sdModule\layuiSearch\generate\TimeRange;
use app\admin\model\Set as I;

class Set extends \app\common\controller\Admin
{
   protected $page_name = "彩蛋设置
";
   
           
    /**
     * 列表数据接口
     * @return array|\Closure|mixed|string|\think\Collection|\think\response\Json
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \Exception
     */
    public function listData()
    {
        return $this->setJoin([
                ['admin', 'i.admin_id = admin.id AND admin.delete_time = 0', 'left'],
            ])
            ->setField('i.id,i.number,i.page,i.title,admin.title admin_id,i.create_time,i.delete_time,i.update_time')
            ->listsRequest();
    }
    
   
    /**
     * 数据新增页面
     * @return mixed|string
     * @throws \Exception
     */
    public function add()
    {
        return $this->fetch('', [
            'set' => I::where(['delete_time' => 0])->column('title', 'id'),
        ]);
    }

   
    /**
     * 数据编辑页面
     * @param int $id
     * @return array|mixed|\think\response\View
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\DbException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \Exception
     */
    public function edit($id = 0)
    {
        return $this->fetch('', [
            'set' => I::where(['delete_time' => 0])->column('title', 'id'),
            'data' => $this->getModel()->where([
                'id' => $id,
                'delete_time' => '0',
            ])->findOrEmpty()->getData(),
        ]);
    }

           
    /**
     * 搜索表单生成
     * @return array|mixed
     */
    public function setSearchForm()
    {
        return [
            SearchForm::Text("i.id", "id")->label(true)->html(),
            SearchForm::Text("i.number", "彩蛋设定数")->label(true)->html(),
            SearchForm::Text("i.page", "触发次数")->label(true)->html(),
            SearchForm::Text("i.title%%", "标题")->label(true)->html(),
            SearchForm::Text("admin.title%%", "用户")->label(true)->html(),
            SearchForm::TimeRange("i.create_time_~", "创建时间")->label(true)->html(TimeRange::TYPE_DATETIME),
            SearchForm::Text("i.delete_time", "删除时间")->label(true)->html(),
            SearchForm::TimeRange("i.update_time_~", "修改时间")->label(true)->html(TimeRange::TYPE_DATETIME),
            
        ];
    }

   
   
}