<?php
/**
 * @remark :
 * @name   :APublicModel.php
 * @author :lyh
 * @method :post
 * @time   :2023/8/10 18:16
 */

namespace App\Models\ASide;

use App\Models\Base;
use App\Services\ProjectServer;
use Illuminate\Support\Facades\DB;

class APublicModel extends Base
{
    const STATUS_ON = 1;
    public static function getProductNumByProjectId($project_id){
        ProjectServer::useProject($project_id);
        return DB::connection('custom_mysql')->table('gl_product')->where('project_id', $project_id)->where('status', self::STATUS_ON)->count();
    }

    public static function getBlogNumByProjectId($project_id){
        ProjectServer::useProject($project_id);
        return DB::connection('custom_mysql')->table('gl_blog')->where('project_id', $project_id)->where('status', self::STATUS_ON)->count();
    }

    public static function getNewsNumByProjectId($project_id){
        ProjectServer::useProject($project_id);
        return DB::connection('custom_mysql')->table('gl_news')->where('project_id', $project_id)->where('status', self::STATUS_ON)->count();
    }
}