ship-expert/app/admin/controller/Repair.php

<?php

// +----------------------------------------------------------------------
// | ThinkAdmin
// +----------------------------------------------------------------------
// | 版权所有 2014~2022 广州楚才信息科技有限公司 [ http://www.cuci.cc ]
// +----------------------------------------------------------------------
// | 官方网站: https://thinkadmin.top
// +----------------------------------------------------------------------
// | 开源协议 ( https://mit-license.org )
// | 免费声明 ( https://thinkadmin.top/disclaimer )
// +----------------------------------------------------------------------
// | gitee 代码仓库：https://gitee.com/zoujingli/ThinkAdmin
// | github 代码仓库：https://github.com/zoujingli/ThinkAdmin
// +----------------------------------------------------------------------

namespace app\admin\controller;

use app\data\model\DataRecruitment;
use app\data\model\DataPoolTalent;
use app\data\model\DataTeachingKnowledge;
use app\data\model\DataUser;
use app\data\model\DataUserAcceptance;
use app\data\model\DataUserRepair;
use app\data\model\DataUserRepairOffer;
use app\data\model\DataZhicheng;
use Carbon\Carbon;
use think\admin\Controller;
use app\data\model\SystemUser;
use think\Db;
use think\db\Query;

/**
 * 维修订单管理
 * Class Repair
 * @package app\admin\controller
 */
class Repair extends Controller
{
    /**
     * 维修订单管理
     * @auth true
     * @menu true
     */
    public function index(){
        $this->title='维修订单列表';
        $name=input('title');
        $order_no = input('order_no');
        //1:未接单 2：已有报价  3：已合作
        $status = [
            1=>'未接单',
            2=>'已接单',
            3=>'已匹配',
        ];
        $this->status = $status;
        $where = [];
        $data = input();
        if(isset($data['status']) && $data['status'] != ""){
            $where['status'] = $data['status'];
        }
        if($name != ""){
            $where[] = ['u.nickname','like','%'.$name.'%'];
        }
        $result = DataUserRepair::mQuery()
            ->alias('r')
            ->leftjoin('data_user u','u.id = r.uuid')
            ->where('is_del',1)
            ->whereLike('order_no',"%$order_no%")
            ->dateBetween('create_at')
            ->where($where)
            ->with(['user'])
            ->order('r.id','desc');
//            ->layTable();
        $this->amount = $result->db()->sum('success_price');
        $result->page();

    }

    protected function _index_page_filter(&$data)
    {
        // dump($data);die;
    }

    public function offer(){
        $this->title='接单记录';
        $name=input('title');
        $order_no = input('order_no');
        $data = input();
        $where = [];
        //
        if(isset($data['repair_id'])){
            $where['repair_id'] = $data['repair_id'];
        }
        $result = DataUserRepairOffer::mQuery()
            ->when($name,function (Query $query) use ($name) {
                $query->hasWhere('user',function (Query $query) use ($name) {
                    $query->whereLike('nickname',"%{$name}%");
                });

            })
            ->when($order_no,function (Query $query) use ($order_no) {
                $query->hasWhere('repair',function (Query $query) use ($order_no) {
                    $query->whereLike('order_no',"%{$order_no}%");
                });

            })
            ->dateBetween('create_at')
            ->with(['user','repair'])
            ->where($where)
            ->order('id','desc');
//            ->layTable();
//        $this->amount = $result->db()->sum('success_price');
        $result->page();
    }

    public function acceptance(){
        $this->title='接单记录';
        $name=input('title');
        $data = input();
        $where = [];
        //
        if(isset($data['name']) && $data['name'] != ''){
            $where[] = ['name','like','%'.$data['name'].'%'] ;
        }
        if(isset($data['company_name'])&& $data['company_name'] != ''){
            $where[] = ['company_name','like','%'.$data['company_name'].'%'] ;
        }
        if(isset($data['create_at'])&& $data['create_at'] != ''){
            $where['create_at'] = $data['create_at'];
        }
        $result = DataUserAcceptance::mQuery()
            ->when($name,function (Query $query) use ($name) {
                $query->hasWhere('user',function (Query $query) use ($name) {
                    $query->whereLike('nickname',"%{$name}%");
                });

            })
            ->dateBetween('create_at')
            ->with(['user'])
            ->where($where)
            ->order('id','desc');
//            ->layTable();
//        $this->amount = $result->db()->sum('success_price');
        $result->page();
    }

    protected function _offer_page_filter(&$data)
    {
        $this->title='接单列表';
        //dump($data);die;
    }

    /**
     * 招聘信息查看
     * @auth true
     * @menu true
     */
    public function audit($id){
        $this->title='招聘信息查看';
        $row=DataUserRepair::mk()
            ->with(['user'])
            ->findOrFail($id);
        if($this->request->isGet()){
            $this->assign('row',$row);
            $this->fetch();
        }else{
            if($row['audit']>1){
                $this->error('该记录已审核');
            }
            $data=$this->_vali([
                'audit.require'=>'结果必须',
                'audit.in:2,3'=>'结果有误',
                'why.requireIf:audit,3'=>'原因必须',
                'why.max:200'=>'原因有误',
            ]);
            $row['audit']=$data['audit'];
            $row['why']=$data['why']??'';
            $row['audit_at']=Carbon::now();
            $row->save();
            if ($data['audit']==2){
                DataUser::mk()->where('id',$row['uuid'])->update(['is_maintenance'=>1]);
            }
            $this->success('审核成功');
        }
    }

}