dingding/application/leave/controller/LeaveInfo.php

<?php
namespace app\leave\controller;
use app\common\model\LeaveApprove;
use library\Controller;
use think\Db;
/**
 * 请假列表
 * Class LeaveInfo
 * @package app\leave\controller
 */
class LeaveInfo extends Controller
{
    /**
     * 绑定数据表
     * @var string
     */
    protected $table = 'LeaveInfo';

    /**
     * 类型列表
     * @auth true
     * @menu true
     * @throws \think\Exception
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     * @throws \think\exception\PDOException
     */
    public function index()
    {
        $this->title = '列表管理';
        $all_type = \app\common\model\LeaveType::getAllType();
        $this->all_type = array_column($all_type,null,'id');
        $sel_where = [];
        if($type = input('type')) $sel_where[] = ['a.type','=',$type];
        if($name = input('name')) $sel_where[] = ['u.name','like','%'.$name.'%'];
        $query = $this->_query($this->table)
            ->field('a.*,u.name,u.headimg')
            ->where($sel_where)
            ->alias('a')
            ->leftJoin('store_member u','u.id = a.user_id')
            ->where('a.is_deleted',0)->page();
    }

    /**
     * 数据列表处理
     * @auth true
     * @menu true
     * @param array $data
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    protected function _index_page_filter(&$data)
    {
        foreach ($data as $k=>&$v){

        }
    }

    /**
     * 删除
     * @auth true
     * @menu true
     * @param array $data
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function remove()
    {
        $this->_save($this->table, ['is_deleted' => '1']);
    }



    /**
     *
     * 编辑
     * @auth true
     * @menu true
     * @param array $data
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    public function edit()
    {
        $this->title = '编辑';
        $this->_form($this->table, 'form');
    }

    /**
     *
     * 数据处理
     * @auth true
     * @menu true
     * @param array $data
     * @throws \think\db\exception\DataNotFoundException
     * @throws \think\db\exception\ModelNotFoundException
     * @throws \think\exception\DbException
     */
    protected function _form_filter(&$data)
    {

    }



    public function approve()
    {
        $id = input('id');
        $list = LeaveApprove::field('a.*,u.name')
            ->where('a.leave_id',$id)
            ->leftJoin('store_member u','u,id = a.approve_user')
            ->select()->toArray();
        $this->assign('list',$list);
        $this->fetch();
    }



}