lw_test/app/admin/controller/Jfm.php

<?php

namespace app\admin\controller;

use app\admin\AdminBaseController;
use app\common\model\AppealModel;
use app\common\model\PolicyModel;
use app\common\validate\PolicyValidate;
use think\exception\ValidateException;

class Jfm extends AdminBaseController
{

    /**
     * 诉求
     */
    public function appeal()
    {
        return view('', [
            'status_list' => AppealModel::STATUS,
        ]);
    }

    public function listAppeal()
    {
        $map   = $this->dealEqualInput(['status']);
        $daterange = input('daterange/s', "");
        if (!empty($daterange)) {
            $daterangearr = explode("~", $daterange);
            $map[]        = ['create_time', '>= time', strtotime(trim($daterangearr[0]))];
            $map[]        = ['create_time', '<= time', strtotime(trim($daterangearr[1]))];
        }
        $list  = AppealModel::where($map)
            ->order(['status' => 'asc','create_time'=>'desc'])
            ->limit(input('limit'))
            ->page(input('page'))
            ->append(['status_text'])
            ->select();
        $count = AppealModel::where($map)->count();
        if ($count == 0) {
            ajax_return(1, '未查询到数据');
        }
        list_return($list, $count);
    }

    public function dealAppeal()
    {
        $id_arr = input('id_arr/a');
        AppealModel::update(['status' => 2], ['id' => $id_arr]);
        ajax_return();
    }

    public function exportAppeal()
    {
        $map  = $this->dealInInput(['id'],$this->dealEqualInput(['status']));
        $daterange = input('daterange/s', "");
        if (!empty($daterange)) {
            $daterangearr = explode("~", $daterange);
            $map[]        = ['create_time', '>= time', strtotime(trim($daterangearr[0]))];
            $map[]        = ['create_time', '<= time', strtotime(trim($daterangearr[1]))];
        }
        $list = AppealModel::where($map)
            ->order(['status' => 'asc','create_time'=>'desc'])
            ->append(['status_text'])
            ->select();

        $xlsCell = [
            ['company_name', '企业名称'],
            ['company_contact', '联系人及职务'],
            ['street', '镇街'],
            ['half_output', '上半年产值（万元）'],
            ['year_output', '全年产值（万元）'],
            ['cate', '需求类别'],
            ['content', '内容'],
            ['filled_by', '填表人'],
            ['mobile', '联系电话'],
            ['status_text', '状态'],
            ['create_time', '填表时间'],
        ];
        export_exl("诉求管理", $xlsCell, $list);
    }

    /**
     * 政策
     */
    public function policy()
    {
        return view('', [
            'status_list' => PolicyModel::STATUS,
        ]);
    }

    public function listPolicy()
    {
        $map   = $this->dealEqualInput(['status']);
        $list  = PolicyModel::where($map)
            ->order(['status' => 'desc'])
            ->limit(input('limit'))
            ->page(input('page'))
            ->append(['status_text'])
            ->select();
        $count = PolicyModel::where($map)->count();
        if ($count == 0) {
            ajax_return(1, '未查询到数据');
        }
        list_return($list, $count);
    }

    public function delPolicy()
    {
        $id_arr = input('id_arr/a');
        PolicyModel::destroy($id_arr);
        ajax_return();
    }

    /**
     * 编辑
     */
    public function policyForm()
    {
        $id      = input('id/d, 0');
        $info = PolicyModel::find($id);

        return view('', [
            'info'     => $info,
            'status_list' => PolicyModel::STATUS,
        ]);
    }

    public function editPolicy()
    {
        $data = input('post.');
        try {
            validate(PolicyValidate::class)->check($data);
        } catch (ValidateException $e) {
            ajax_return(1, $e->getError());
        }

        if (empty($data['id'])) {
            PolicyModel::create($data);
        } else {
            PolicyModel::update($data, ['id' => $data['id']]);
        }

        ajax_return();
    }
}