thinkphp-butter/app/service/CheckService.php

<?php

namespace app\service;




use app\model\Check;
use think\facade\Db;

class CheckService
{
    public static function getCheckList($page,$xzqdm){
       return Db::name("check")->field("t_check.*,count(t_check.qydm) as check_count,e.enterprises_name")->where("t_check.qydm","like",$xzqdm."%")->leftJoin("t_enterprises e","e.qydm=t_check.qydm")->page($page["page"],$page["size"])->select();
    }
    public static function addCheck($data){
        $res=Check::create($data);
        return $res->id;
    }

}