xiaoding-backend-php/app/Http/Services/Backend/Server/Service/ProjectService.php

<?php
/**
 * @Name
 * @Description
 * @Author 刘学玺
 * @Date 2024/8/27 10:52
 */

namespace App\Http\Services\Backend\Server\Service;

use App\Http\Services\Service;
use App\Models\Service\Category;
use App\Models\Service\Project;
use App\Models\System\Dept;
use App\Models\System\DictData;
use App\Models\System\DictType;
use Symfony\Component\HttpFoundation\Response;

class ProjectService extends Service
{
    protected array $simpleColumn = ['id', 'title', 'cover'];
    protected array $selectColumn = ['price', 'init_price as initPrice', 'material_price as materialPrice', 'time_long as timeLong', 'sort', 'status'];
    protected array $appendColumn = ['created_at as createTime'];

    public function getProjectList($params)
    {
        $project = Project::query();
        isset($params['title']) && filled($params['title']) && $project->whereLike('title', "%{$params['title']}%");
        isset($params['status']) && filled($params['status']) && $project->where('status', $params['status']);
        !empty($params['createTime']) && $project->whereIn('created_at', $params['createTime']);
        $projectPage = $project->paginate($params['pageSize'], [...$this->simpleColumn, ...$this->selectColumn, ...$this->appendColumn], 'page', $params['pageNo']);
        return ['list' => $projectPage->items(), 'total' => $projectPage->total()];
    }

    public function createProject(array $data)
    {
        $collection = collect($data);
        $category = $collection->forget('category');
        $project = self::toModel($collection, Project::class);
        return $project->create($project->getAttributes())->id;
    }

    public function getProject(int $id)
    {
        return Project::query()->select([...$this->simpleColumn, ...$this->selectColumn])->find($id);
    }

    public function updateProject(array $data, int $id): void
    {
        $project = self::toModel($data, Project::class);
        $project->where('id', $id)->update($project->getAttributes());
    }

    public function deleteProject(int $id)
    {
        $project = self::toModel(['id' => $id], Project::class);
        return $project->delete();
    }
}